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.| 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 |