Write a SQL query using window functions to find the top-performing energy assets in each region at Shell.
Use the provided asset and production data. Treat total production during 2025 as the performance measure and include only active assets.
region, asset_id, asset_name, total_production_mwh, and performance_rankregion and asset_id| Column | Type | Description |
|---|---|---|
| asset_idPK | INT | Unique energy asset identifier |
| asset_name | VARCHAR(100) | Display name of the energy asset |
| region | VARCHAR(100) | Geographic operating region |
| status | VARCHAR(20) | Operational status of the asset |
| Column | Type | Description |
|---|---|---|
| production_idPK | INT | Unique production measurement identifier |
| asset_id | INT | Referenced energy asset |
| production_date | DATE | Date of the production measurement |
| production_mwh | NUMERIC(14,2) | Energy produced in megawatt-hours |