Contents of BOOKS Table

Multiple Choice

Contents of BOOKS table
​
-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will list all books stored in the BOOKS table with a retail price of more than $38 sorted by retail price?​

A) ​SELECT * FROM books WHERE retail >38 SORT BY retail;
B) ​SELECT * FROM books WHERE retail >38 SORTED BY retail;
C) ​SELECT * FROM books WHERE retail >38 ORDERED BY retail;
D) ​SELECT * FROM books WHERE retail >38 ORDER BY retail;