Contents of the BOOKS table

-Which of the following will display the new retail price of each book as 20 percent more than it originally cost?
A) none of the above
B) SELECT title,cost+.20 "New Retail Price" FROM books;
C) SELECT title,cost*.20 "New Retail Price" FROM books;
D) SELECT title,cost*1.20 "New Retail Price" FROM books;

Question

Contents of the BOOKS table
 
-Which of the following will display the new retail price of each book as 20 percent more than it originally cost?​
A) ​none of the above 
B) ​SELECT title,cost+.20 "New Retail Price" FROM books; 
C) ​SELECT title,cost*.20 "New Retail Price" FROM books; 
D) ​SELECT title,cost*1.20 "New Retail Price" FROM books;

Quizplus · Accepted Answer

To obtain the new retail price of each book as 20% more than its original cost, we need to multiply the original cost by 1.20 (which is equal to adding 0.20 or 20% to the original cost). Therefore, the correct SQL query is:
SELECT title, cost * 1.20 as "New Retail Price" FROM books;
Option B incorrectly adds 0.20 to the original cost, while Option C incorrectly multiplies the original cost by 0.20. Option A will not produce any output.

Contents of the BOOKS Table