皮皮学，免费搜题
登录
搜题
【单选题】
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．You are special. B．You are natural. C．You are stupid. D．You are dumb.
【简答题】C If you are a male and you are reading this, congratulations: you are a survivor. According to statistics, you are more than twice as likely to die of skin cancer than a woman, and nine times more li...
【单选题】下列 电路输出端 不可以 直接并联使用。 A. CMOS 传输门 B. CMOS 电路的 OD 门 C. TTL 电路的 OC 门 D. TTL 三态门
A.
B.
C.
D.
D
【简答题】V 带是横截面为 或近似为 的传动带。
相关题目：