SQL: Weekly Incidents Trends | Dataford Interview Questions

Write a SQL query to track weekly security incidents by region and severity, showing trends over time at Cloud Security Services.

Use the provided security incident, region, and severity data. Include only incidents with a valid timestamp, region, and severity.

Output

One row per week, region, and severity with at least one matching incident.
Columns: week_start, region, severity, and incident_count.
Sort by week ascending, region ascending, and severity priority from highest to lowest.

security_incidents

Column	Type	Description
incident_idPK	INT	Unique incident identifier
occurred_at	TIMESTAMP	Timestamp when the incident occurred
region_id	INT	Region associated with the incident
severity_id	INT	Severity classification of the incident

regions

Column	Type	Description
region_idPK	INT	Unique region identifier
region_name	VARCHAR(100)	Cloud Security Services operating region

severity_levels

Column	Type	Description
severity_idPK	INT	Unique severity identifier
severity_name	VARCHAR(50)	Severity label
priority_order	INT	Sort order from most severe to least severe

Your question is SQL: Weekly Incidents Trends. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.