Aggregating Sales by Region

EasySQL · PostgreSQL

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

Tablessales_transactions

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.