【单项选择题】
You want to display the titles of books that meet these criteria:<br /> 1. Purchased before January 21, 2001<br /> 2. Price is less then $500 or greater than $900<br /> You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use? （）<p> You want to display the titles of books that meet these criteria:<br /> 1. Purchased before January 21, 2001<br /> 2. Price is less then $500 or greater than $900<br /> You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use? （）</p>
A、A. SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date;
B、B. SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC;
C、C. SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;
D、D. SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;
查看正确答案
