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 |