Top Categories SQL Query | Dataford Interview Questions

Write a SQL query to find the top three most frequently ordered food categories by region over the last quarter for Sysco. Count each order line as one category order, exclude records outside the previous calendar quarter, and ignore lines without a category or matching order.

Output

One row per qualifying region and category, with region, food_category, order_count, and category_rank.
Return no more than three categories per region, ordered by region, order count descending, category name ascending, and rank ascending.

Schema

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
region	VARCHAR(50)	Sysco sales region for the order
ordered_at	DATE	Date the order was placed

order_lines

Column	Type	Description
order_line_idPK	INT	Unique order line identifier
order_id	INT	Order associated with the line
food_category	VARCHAR(80)	Food category ordered on the line

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