Contents of the BOOKS table

-Based upon the contents of the BOOKS table, which of the following SQL statements will display two columns in its output?
A) SELECT * FROM books;
B) SELECT title, retail-cost "Profit" FROM books;
C) SELECT DISTINCT title FROM books;
D) all of the above

Question

Contents of the BOOKS table
 
-Based upon the contents of the BOOKS table, which of the following SQL statements will display two columns in its output?
A) SELECT * FROM books; 
B) SELECT title, retail-cost "Profit" FROM books; 
C) SELECT DISTINCT title FROM books; 
D) all of the above

Quizplus · Accepted Answer

Option A will display all the columns in the BOOKS table whereas option C will display only the distinct titles in the BOOKS table. Option B is the only one that specifies which columns to display (title and retail-cost) and also renames the retail-cost column as "Profit". Therefore, the correct answer is B.

Contents of the BOOKS Table