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 return the category and title of all books stored in the BOOKS table presented in order of their category and,for the books in the same category,sort the title of the books in descending order?

A) ​SELECT category,title FROM books
ORDERED BY 1,2 DESC;
B) ​SELECT category,title FROM books
ORDER BY 1 ASC,2 DESC;
C) ​SELECT category,title FROM books
SORTED BY 1 ASC,2 DESC;
D) ​SELECT category,title FROM books
SORT BY 1,2 DESC;