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

Question

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

Quizplus · Accepted Answer

The correct syntax for sorting by category and then by retail price is ORDER BY category, retail. Option A is the only choice that correctly uses the ORDER BY clause and specifies the correct fields to order by. Option B uses the incorrect keyword ORDERED and Option C uses the incorrect keyword SORT BY. Option D is not a valid answer as it provides no alternative query.

Contents of BOOKS Table