QUESTION: Display a list of all book titles and the percentage of markup for eac

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;

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.