Write a SQL query to analyze operational performance by team at Amazon Web Services, including joins across business tables and aggregation of key metrics.
Use the available tables to return one row per team. Include only teams with at least one operational record in the analysis period.
| Column | Type | Description |
|---|---|---|
| team_idPK | INT | Unique team identifier |
| team_name | VARCHAR(100) | Team name |
| org_unit | VARCHAR(100) | Business unit or organization |
| region | VARCHAR(50) | Primary operating region |
| Column | Type | Description |
|---|---|---|
| incident_idPK | INT | Unique incident identifier |
| team_id | INT | Team responsible for the incident |
| status | VARCHAR(20) | Incident status such as Open or Resolved |
| created_at | TIMESTAMP | Incident creation timestamp |
| resolved_at | TIMESTAMP | Incident resolution timestamp, null if still open |
| affected_accounts | INT | Number of affected customer accounts |
| severity | VARCHAR(10) | Incident severity level |