Total Sales by Region | Dataford Interview Questions

Business Context

Blue Yonder Luminate Planning users need a regional view of sales performance for operational reporting. The source data contains one row per sales transaction.

Task

Write a PostgreSQL query that calculates total sales by region from the sales_transactions table.

Requirements

Group transactions by region and calculate the sum of sale_amount for each region.
Return all regions, including transactions where the region is unknown, and sort the results by total sales from highest to lowest.

Schema

sales_transactions

Column	Type	Description
transaction_idPK	INTEGER	Unique sales transaction identifier
region	VARCHAR(50)	Sales region associated with the transaction
sale_amount	DECIMAL(12,2)	Transaction sales amount
transaction_date	DATE	Date of the sales transaction

Your question is Total 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.

Problem