Apply Publisher Promotions to Book Prices

Problem

An online bookstore runs promotions by publisher. Each book belongs to one publisher and has a list_price in whole shekels. A promotions table gives a percentage_off for some publishers. Compute the checkout_price for every book as list_price minus list_price * percentage_off / 100. Books whose publisher has no promotion keep their list_price unchanged. Return book_id, checkout_price and publisher, ordered by book_id.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 4 rows with the columns book_id, checkout_price, publisher.

Starter code (SQL)

SELECT *
FROM books;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium