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) SELECT title, cost+.20 "New Retail Price" FROM books;
B) SELECT title, cost*.20 "New Retail Price" FROM books;
C) SELECT title, cost*1.20 "New Retail Price" FROM books;
D) none of the above

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) SELECT title, cost+.20 "New Retail Price" FROM books; 
B) SELECT title, cost*.20 "New Retail Price" FROM books; 
C) SELECT title, cost*1.20 "New Retail Price" FROM books; 
D) none of the above

Quizplus · Accepted Answer

The correct formula for 20% increase in price is to multiply the original cost by 1.20. Therefore, the query should be "SELECT title, cost*1.20 AS 'New Retail Price' FROM books". Choice A adds 20 to the original cost, which is incorrect. Choice B multiplies the original cost by 0.20, which calculates the 20% discount instead of increase.

Contents of the BOOKS Table