Top Three Selling Products SQL | Dataford Interview Questions

Your question is Top Three Selling Products SQL. Start with the requirements and the three tables on the right.

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

Problem

Business Context

DICK'S Sporting Goods wants a regional sales view to identify the best-selling products across its store regions. Product rankings should be based on completed sales during calendar year 2025.

Task

Write a PostgreSQL query that returns the top three products by total units sold for each region.

Requirements

Join the regional, product, and sales data.
Include only sales with sale_status = 'completed' and sale dates in 2025.
Aggregate units sold by region and product, then rank products within each region using a window function.
Return the region name, product name, total units sold, and rank. Break ties alphabetically by product name and sort the final output by region and rank.

Schema

regions

Column	Type	Description
region_idPK	INT	Unique regional identifier
region_name	VARCHAR(50)	DICK'S Sporting Goods sales region name

products

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

sales

Column	Type	Description
sale_idPK	INT	Unique sale record identifier
region_id	INT	Region associated with the sale
product_id	INT	Product associated with the sale
units_sold	INT	Number of units sold
sale_status	VARCHAR(20)	Transaction status
sale_date	DATE	Transaction date