Top Three Sales by Region | Dataford Interview Questions

Write a SQL query to find the top three highest sales by region.

Use the provided regional and sales data. Return the three highest-value sales for every region that has sales, excluding regions without sales and sales assigned to unknown regions.

Output

One row per selected sale, with region_name, sale_id, sale_amount, and sale_rank.
Include at most three rows per region, ranked from highest to lowest sale amount.
Order by region_name, then sale_rank, then sale_id.

Schema

regions

Column	Type	Description
region_idPK	INT	Unique identifier for a sales region
region_name	VARCHAR(100)	Display name of the sales region

sales

Column	Type	Description
sale_idPK	INT	Unique identifier for a sale
region_id	INT	Identifier of the associated region
sale_amount	NUMERIC(12,2)	Value of the sale

Your question is Top Three Sales by Region. Start with the requirements and the two 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