Aggregating Sales by Region | Dataford Interview Questions

Write a SQL query to aggregate sales data by region.

Use the sales_transactions table. Return one row for each region, including rows where the region is NULL.

Output

sales_transactions

Column	Type	Description
sale_idPK	INT	Unique identifier for the sale
region	VARCHAR(50)	Sales region
sales_amount	DECIMAL(12,2)	Sales amount for the transaction

Your question is Aggregating Sales by Region. Start with the requirements and the one table 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.

Write a SQL query to aggregate sales data by region.

Use the sales_transactions table. Return one row for each region, including rows where the region is NULL.

sales_transactions

Column	Type	Description
sale_idPK	INT	Unique identifier for the sale
region	VARCHAR(50)	Sales region
sales_amount	DECIMAL(12,2)	Sales amount for the transaction

Your question is Aggregating Sales by Region. Start with the requirements and the one table 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.