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;

Question

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;

Quizplus · Accepted Answer

The query should start with "SELECT category, title FROM books", which will select the category and title columns from the table. The "ORDER BY" clause must sort the results first by category in ascending order (1 ASC), and then by title in descending order (2 DESC). Therefore, option B is the correct query. Options A, C, and D are incorrect because they either use the wrong keywords or invalid syntax.

Contents of BOOKS Table