题目内容

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 purchase, starting with the most recently bought book. 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_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

查看答案
更多问题

将土壤矿质颗粒分为物理性沙粒和物理性黏粒的科学家是()

A. 美国人
B. 中国人
C. 德国人
D. 前苏联人

航行区域的限制

在运动前用餐有利于健康,但是在运动前的()

A. 1-3
B. 2-3
C. 1-2
D. 2-4

素描水平发展经历了哪四个发展阶段()、()、()、()。

答案查题题库