Contents of the BOOKS table

-Based upon the contents of the BOOKS table,which of the following SQL statements will display the retail price for two copies of each book currently in inventory?
A) SELECT * FROM books;
B) SELECT title,retail+retail FROM books;
C) none of the above
D) SELECT title,retail^2 FROM books;

Question

Contents of the BOOKS table
 
-​Based upon the contents of the BOOKS table,which of the following SQL statements will display the retail price for two copies of each book currently in inventory?
A) ​SELECT * FROM books; 
B) ​SELECT title,retail+retail FROM books; 
C) ​none of the above 
D) ​SELECT title,retail^2 FROM books;

Quizplus · Accepted Answer

Option A would display all columns of the BOOKS table without performing any mathematical operations on the retail price column. Option D would square the retail price column, making the values irrelevant for our question. Option B adds the retail price to itself, effectively doubling it, and displays the title and the doubled retail price. Therefore, option B is the best choice for displaying the retail price for two copies of each book currently in inventory.

Contents of the BOOKS Table