Your question is Analyze Outlet Sales by Region. Start with the requirements and the three tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
You are given sales activity from Coca-Cola Consolidated outlets and asked to turn it into actionable insight. Write a PostgreSQL query that returns, for each region and month in Q1 2024, the total revenue, total units sold, number of active outlets with at least one completed sale, and an insight label showing whether the region is Growing, Declining, or Flat compared with the prior month based on revenue. Only include completed sales in the analysis.
| Column | Type | Description |
|---|---|---|
| region_idPK | INT | Unique region identifier |
| region_name | VARCHAR(50) | Coca-Cola Consolidated region name |
| Column | Type | Description |
|---|---|---|
| outlet_idPK | INT | Unique outlet identifier |
| outlet_name | VARCHAR(100) | Outlet name |
| region_id | INT | Region assigned to the outlet |
| outlet_type | VARCHAR(30) | Outlet channel type |
| opened_date | DATE | Outlet opening date |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sale identifier |
| outlet_id | INT | Outlet where the sale occurred |
| sale_date | DATE | Date of sale |
| units_sold | INT | Cases sold |
| revenue | DECIMAL(10,2) | Revenue from the sale |
| sale_status | VARCHAR(20) | Sale status |