Question: 2.
You want to display the titles of books that meet these criteria:
1. Purchased before January 21, 20012.
Price is less then $500 or greater than $900
You want to sort the results by their data of purchase, starting with the most recently boughtbook.
Which statement should you use?
A. SELECT book_title FROM books
WHERE price between 500 and 900
AND purchase_date < '21-JAN-2001'
ORDER BY purchase_date;
B. SELECT book_titleFROM books
WHERE price IN (500,900)
AND purchase_date < '21-JAN-2001'
ORDER BY purchase date ASC;
C. SELECT book_titleFROM books
WHERE price <> 900
AND purchase_date < '21-JAN-2001'
ORDER BY purchase date DESC;
D. SELECT book_titleFROM books
WHERE (price <> 900)
AND purchase_date < '21-JAN-2001'
ORDER BY purchase date DESC;
Answer: D
Explanation:
This statement provides required results.
Incorrect Answers:
A: This query will show books with price in range $500 and $900, not less then $500 or greater than $900.
B: This query will show books with prices exactly $500 or $900, not less then $500 or greaterthan $900.
C: This order will not show correct rows because of incorrect syntax in the WHERE clause.
Comments