Your question is SQL Fundamentals. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |