Top 3 Products Per Region | Dataford Interview Questions

Abbott's commercial analytics team needs a regional view of its best-selling medical device products. Write a PostgreSQL query for the last completed quarter, defined here as 2025-04-01 through 2025-06-30.

Requirements

Include only orders with status = 'Completed' during the specified quarter.
Join regions, orders, order items, and products to calculate total units sold by region and product.
Return the top three products within each region, ranking by total units sold descending and resolving ties by product_name ascending.
Exclude products with non-positive or NULL quantities and return regions with qualifying sales only.

Schema

regions

Column	Type	Description
region_idPK	INTEGER	Unique Abbott sales region identifier
region_name	VARCHAR(100)	Sales region name

sales_orders

Column	Type	Description
order_idPK	INTEGER	Unique sales order identifier
region_id	INTEGER	Region assigned to the order
order_date	DATE	Date the order was placed
status	VARCHAR(20)	Order processing status

sales_order_items

Column	Type	Description
order_idPK	INTEGER	Related sales order identifier
product_idPK	INTEGER	Related medical device product identifier
quantity	INTEGER	Number of units sold

products

Column	Type	Description
product_idPK	INTEGER	Unique product identifier
product_name	VARCHAR(150)	Abbott medical device product name

Your question is Top 3 Products Per Region. Start with the requirements and the four 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