Your question is Running Total of Incidents by Day. 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.
Cloud Security Services needs a daily view of incidents handled by its security teams. Write a PostgreSQL query that counts incidents for the requested reporting period and calculates the cumulative total over time.
service_area is Cloud Security Services.| Column | Type | Description |
|---|---|---|
| incident_idPK | INT | Unique incident identifier |
| team_id | INT | Assigned security team identifier |
| occurred_at | DATE | Date the incident occurred |
| severity | VARCHAR(20) | Incident severity |
| Column | Type | Description |
|---|---|---|
| team_idPK | INT | Unique team identifier |
| team_name | VARCHAR(100) | Security team name |
| service_area | VARCHAR(100) | Service area supported by the team |