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;

Question

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;

Quizplus · Accepted Answer

The correct syntax for sorting data by a specific column is "ORDER BY" and not "SORT" or "SORTED". Therefore, options A and B are incorrect due to the use of "SORT" or "SORTED". Option C is close, but uses the incorrect keyword "ORDERED" instead of "ORDER". Option D correctly uses "ORDER BY" and specifies the column to sort by, which is "retail". Therefore, option D is the best choice.

Contents of BOOKS Table