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) SELECT title, retail^2 FROM books;
D) none 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 the retail price for two copies of each book currently in inventory?
A) SELECT * FROM books; 
B) SELECT title, retail+retail FROM books; 
C) SELECT title, retail^2 FROM books; 
D) none of the above

Quizplus · Accepted Answer

Option A will display all the columns from the table, but it will not include the retail price of two copies of each book.
Option C is using a bitwise operator (^), which will not give the desired output. 
Option B, however, will display the title column and the sum of retail price for two copies of each book as "retail+retail."

Contents of the BOOKS Table