SQL for Top Categories by Region | Dataford Interview Questions

Write a query to identify the top three selling product categories for each region in the last fiscal quarter.

Assume fiscal quarters align with calendar quarters and use the last completed quarter relative to CURRENT_DATE. Include completed orders only, and calculate sales as quantity multiplied by unit price.

Output

One row per qualifying region and category, with region, category, total_sales, and category_rank.
Include at most three categories per region. Break revenue ties alphabetically by category.
Order by region, then category_rank, then category.

Schema

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
region	VARCHAR(50)	Customer region associated with the order
product_id	INT	Purchased product identifier
order_date	DATE	Date the order was placed
quantity	INT	Number of units purchased
unit_price	NUMERIC(10,2)	Price per unit at the time of purchase
status	VARCHAR(20)	Order fulfillment status

products

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

Your question is SQL for Top Categories 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