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 display the title and retail price of each book stored in the BOOKS table in order of category and retail price?​

A) ​SELECT title,retail FROM books
ORDER BY category,retail;
B) ​SELECT title,retail FROM books
ORDERED BY category,retail;
C) ​SELECT title,retail FROM books
SORT BY category,retail;
D) ​none of the above