Are you good at SQL?
Given the services and monitoring_events tables, write a query for January 2025 that summarizes events for every active service, including services with no matching events.
service_name, event_count, critical_count, and avg_resolution_minutes.event_count descending, then service_name ascending.| Column | Type | Description |
|---|---|---|
| service_idPK | INT | Unique service identifier |
| service_name | VARCHAR(100) | Service display name |
| is_active | BOOLEAN | Whether the service is currently active |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique monitoring event identifier |
| service_id | INT | Referenced service identifier |
| occurred_at | TIMESTAMP | Timestamp when the event occurred |
| severity | VARCHAR(20) | Event severity |
| resolution_minutes | DECIMAL(8,1) | Minutes required to resolve the event |