Contents of BOOKS table

-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will list the title and retail price of each book stored in the BOOKS table,sorted in order of the book titles?
A) SELECT title,retail FROM books ORDERED BY title;
B) SELECT title,retail FROM books SORTED BY title;
C) SELECT title,retail FROM books ORDER BY title;
D) SELECT title,retail FROM books SORT BY title;

Question

Contents of BOOKS table
  ​
-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will list the title and retail price of each book stored in the BOOKS table,sorted in order of the book titles?​
A) ​SELECT title,retail FROM books ORDERED BY title; 
B) ​SELECT title,retail FROM books SORTED BY title; 
C) ​SELECT title,retail FROM books ORDER BY title; 
D) ​SELECT title,retail FROM books SORT BY title;

Quizplus · Accepted Answer

The correct query for this purpose is "SELECT title,retail FROM books ORDER BY title;". In this query, we select the columns "title" and "retail" from the "books" table and order them by the "title" column in ascending order. Option A, B, and D all contain incorrect syntax for sorting the data in ascending or descending order.

Contents of BOOKS Table