Write a SQL query to calculate monthly utilization trends and running totals for project delivery metrics.
Use the provided project and delivery metric data. Include only active projects and metric records from January through March 2025.
month, total_planned_hours, total_billable_hours, utilization_pct, total_delivered_value, running_planned_hours, running_billable_hours, and running_delivered_value.month as YYYY-MM.NULL for utilization_pct when monthly planned hours equal zero.| Column | Type | Description |
|---|---|---|
| project_idPK | INT | Unique project identifier |
| project_name | VARCHAR(150) | Project name |
| status | VARCHAR(20) | Project lifecycle status |
| Column | Type | Description |
|---|---|---|
| metric_idPK | INT | Unique delivery metric identifier |
| project_id | INT | Referenced project |
| metric_date | DATE | Date represented by the metric |
| planned_hours | INT | Hours planned for delivery |
| billable_hours | INT | Billable delivery hours |
| delivered_value | NUMERIC(12,2) | Value delivered for the metric record |