【单选题】You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of pur...
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_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC;
C.
SELECT book_title FROM books WHERE price < 500 or> 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;
D.
SELECT book_title FROM books WHERE (price < 500 OR price> 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;