Examine the description of the BOOKS table:
Examine these requirements:
1. Display book titles for books purchased before January 17, 2007 costing less than 500 or more than 1000.
2. Sort the titles by date of purchase, starting with the most recently purchased book.
Which two queries can be used? (Choose two.)
The correct queries should fulfill both conditions: display book titles for books purchased before January 17, 2007, costing less than 500 or more than 1000 and sort the titles by the date of purchase in descending order. Both options C and E meet these requirements. They correctly filter the price conditions and use DESC in the ORDER BY clause to sort in descending order. Options A and D are incorrect because they contain syntax errors or incorrect conditions.
CE is correct
CE is correct A have incorrect syntax
CE is correct. A - where condition should have 'price' as well for 1000 B - where condition 'between 500 and 1000' does not satisfy what is asked; 'order by' clause's default is ascending D - where condition 'price IN (500,1000)' and order by ASC is wrong
A is not valid . CE is the correct
B&D can be eliminated straight away by looking at the ORDER BY AESC because the question states that the highest date should be first which means DESC should be used with the column PURCHASE_DATE Rule out A because of syntax error in OR operator usage C & D is correct
Correction C & E is correct Answer
where (price < 500 or >1000) it is not correct. where (price <500 or price >1000) it is correct. CE correct answer
A gives error because of > 1000
Price needs to be repeated after the OR statement, so C,E correct. A results in error
A results in an error and to get the most recent you need to order by desc