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 DISTINCT title FROM books;
B) all of the above
C) SELECT * FROM books;
D) SELECT title,retail-cost "Profit" FROM books;

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 DISTINCT title FROM books; 
B) ​all of the above 
C) ​SELECT * FROM books; 
D) ​SELECT title,retail-cost "Profit" FROM books;

Quizplus · Accepted Answer

Option D include both Title and profit columns in the output, which is what is required. Option A only includes the title column, option C includes all columns in the table and option B includes all possible options including those that do not display two columns.

Contents of the BOOKS Table