Window Functions for Product Ranking | Dataford Interview Questions

Write a SQL query using window functions to rank products by sales within each region.

Use the provided sales, product, and region tables. Include only sales linked to a valid product and region.

Output

One row per product and region
Columns: region_name, product_name, total_sales, and sales_rank
Rank products by descending total sales within each region, with ties sharing the same rank
Order by region_name, sales_rank, then product_name

sales_transactions

Column	Type	Description
transaction_idPK	INT	Unique sales transaction identifier
product_id	INT	Referenced product identifier
region_id	INT	Referenced sales region identifier
sales_amount	DECIMAL(12,2)	Sales amount for the transaction

products

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

sales_regions

Column	Type	Description
region_idPK	INT	Unique sales region identifier
region_name	VARCHAR(100)	Sales region name

Your question is Window Functions for Product Ranking. Start with the requirements and the three 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.