SQL Top Five Products | Dataford Interview Questions

Write a SQL query to retrieve the top five products by sales volume.

Use completed orders and count only positive item quantities as sales volume. Return products with recorded sales, ordered from highest volume to lowest, with product ID as the tie-breaker.

Output

One row per product with columns product_id, product_name, and sales_volume
Include only the five highest-volume products
Order by sales_volume descending, then product_id ascending

Schema

products

Column	Type	Description
product_idPK	INT	Unique product identifier
product_name	VARCHAR(100)	Product display name

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
status	VARCHAR(20)	Order state, such as completed, pending, or cancelled

order_items

Column	Type	Description
order_item_idPK	INT	Unique order item identifier
order_id	INT	References orders.order_id
product_id	INT	References products.product_id
quantity	INT	Number of units on the order item

Your question is SQL Top Five Products. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem