Contents of the BOOKS table

-Which of the following SQL statements will display the profit generated by each book currently stored in the BOOKS table?
A) SELECT * FROM books;
B) SELECT title, retail, cost profit FROM books;
C) SELECT title, retail-cost FROM books;
D) all of the above

Question

Contents of the BOOKS table
 
-Which of the following SQL statements will display the profit generated by each book currently stored in the BOOKS table?
A) SELECT * FROM books; 
B) SELECT title, retail, cost profit FROM books; 
C) SELECT title, retail-cost FROM books; 
D) all of the above

Quizplus · Accepted Answer

Option A will display all the columns of the table, but it does not calculate the profit. Option B contains an incorrect syntax as it is trying to select "profit" without actually calculating it. Option C calculates the profit by subtracting the cost from the retail price for each book, which is what is required in the question prompt. Therefore, option C is the correct one.

Contents of the BOOKS Table