Your question is Top Regions Month Over Month. Start with the requirements and the two 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.
Siemens Healthineers wants to monitor monthly commercial performance across regions. Write a PostgreSQL query that compares medical equipment sales with monthly regional targets and identifies the three strongest regions for each month.
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique medical equipment sale identifier |
| region_code | VARCHAR(20) | Region responsible for the sale |
| sale_date | DATE | Date on which the sale was recorded |
| equipment_model | VARCHAR(100) | Siemens Healthineers equipment model sold |
| sale_amount | NUMERIC(12,2) | Value of the equipment sale |
| Column | Type | Description |
|---|---|---|
| target_idPK | INT | Unique monthly target identifier |
| region_code | VARCHAR(20) | Region to which the target applies |
| target_month | DATE | First day of the target month |
| target_amount | NUMERIC(12,2) | Monthly sales target for the region |