【单选题】若数据表“BOOK”中有“书号”(字符型).“书名”(字符型)和“单价”(数值型)等字段,要查询单价在20~80之间(含20和80)的书籍信息,并按单价降序排列,正确的SQL命令是( )。
A.
SELECT * FROM BOOK WHERE 单价 BETWEEN 20 AND 80 ORDER BY 单价 DESC
B.
SELECT * FROM BOOK WHERE 单价>= 20 AND 单价<=80 ORDER BY 单价< /div>
C.
SELECT * FROM BOOK WHERE NOT (单价<20 AND 单价>80) ORDER BY 单价 DESC
D.
SELECT * FROM BOOK WHERE 单价 BETWEEN 20 AND 80 ORDER BY 单价
【单选题】听力原文:W: Dr Manning, do you have a few minutes? I'd like to ask you about this fossil I found. M: Sure. What have you got there? W: Well, it's some kind of shellfish. I thought it might be a brachiopod...
A.
Ways to determine the age of a fossil.
B.
A comparison of two shellfish fossils.
C.
The identity of a fossil the woman found.
D.
Plans for a field trip to look for fossils.
【单选题】听力原文:Q: How do you like to be addressed, as Dr. Black or David? (A) It's up to her to decide. (B) David's fine. (C) To the address listed on top. (12)
【单选题】听力原文:W: Dr Manning, do you have a few minutes? I'd like to ask you about this fossil I found. M: Sure. What have you got there? W: Well, it's some kind of shellfish. I thought it might be a brachiopod...
A.
Ways to determine the age of a fossil.
B.
The identity of a fossil the woman found.
C.
A comparison of two shellfish fossils.
D.
Plans for a field trip to look for fossils.