SQL Top 5 Regions Query | Dataford Interview Questions

A sales analytics team needs a quarterly regional revenue ranking. Write a SQL query to calculate total revenue for each region during the previous calendar quarter relative to the reporting date of September 15, 2026.

Output

Return one row per region with columns region_name and total_revenue.
Include regions with no qualifying sales, treating their total revenue as zero. Ignore sales whose region does not match a region record, sales with a NULL region, and NULL revenue values.
Sort by total_revenue descending, then region_name ascending, and return only the first five rows.

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	Region associated with the sale
sale_date	DATE	Date when the sale was recorded
revenue	NUMERIC(12,2)	Revenue amount for the sale, including adjustments

Your question is SQL Top 5 Regions Query. 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