Revenue by Product

Challenge brief

Understand the request

Finance Team is preparing the quarterly P&L and needs total subscription revenue broken down by product line.

Sum subscription prices per product name by joining subscriptions to products.

Data you will use

Review the relevant tables before deciding how to join, filter, or aggregate them.

Hints, when you need them

Open one clue at a time so you still do the reasoning.

Verified SQL answer

Attempt the problem first, then compare structure and reasoning—not just syntax.

SELECT p.product_name, COALESCE(SUM(s.price), 0) AS revenue FROM products p LEFT JOIN subscriptions s ON p.product_id = s.product_id GROUP BY p.product_id, p.product_name ORDER BY revenue DESC, p.product_name;

Expected result

Use this output to verify values, aliases, ordering, and row count.