SQL基本查询语句的使用 — 信息技术选择题
题目
已知图书表 Books(book_id, title, author, price),要查询价格低于50元的图书的书名和作者,正确的 SQL 语句是( )。
A. SELECT title, author FROM Books WHERE price<50
B. SELECT * FROM Books WHERE title, author
C. SELECT title, author FROM Books ORDER BY price<50
D. SELECT title AND author FROM Books WHEN price<50