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

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

Quizplus · Accepted Answer

Option A is incorrect because it includes the keyword "FROM" without specifying a table to select from. Additionally, it doesn't perform any calculations on the cost and retail columns to generate the profit.
Option C is incorrect because it includes both options A and B, which is redundant.
Option D is incorrect because it selects all columns in the BOOKS table, which includes columns that are not relevant to calculating the profit (such as the unique identifier for each book). 
Therefore, option B is the correct answer as it selects only the book title, and performs the necessary calculation of retail-cost to display the profit for each book.

Contents of the BOOKS Table