QUESTION: Display a list of all book titles and the percentage of markup for eac
ID: 3540105 • Letter: Q
Question
QUESTION: Display a list of all book titles and the percentage of markup for each book. The percentage of markup should be displayed as a whole number (that is, multiplied by 100) with no decimal position, followed by a percent sign (for example, .2793 = 28%). (The percentage of markup should reflect the difference between the retail and cost amounts as a percent of the cost.).
TABLE:
BOOKS
Name Null Type
-------- -------- ------------
ISBN NOT NULL VARCHAR2(10)
TITLE VARCHAR2(30)
PUBDATE DATE
PUBID NUMBER(2)
COST NUMBER(5,2)
RETAIL NUMBER(5,2)
DISCOUNT NUMBER(4,2)
CATEGORY VARCHAR2(12)
Explanation / Answer
SELECT title, to_char(round((retail-cost)/retail*100), '99') AS "MARKUP %" FROM BOOKS;