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 |