SQL Practice Logo

SQLPractice Online

Level 10 - MasterQuery-Based Questionsm5 architecture leadership decision rounds

Executive Architecture Scoreboard Query

Write SQL to return team_name, total_incidents, and avg_restore_minutes for the last 30 days from incident_log, sorted by total_incidents desc.

Schema Context

incident_log(incident_id, team_name, restore_minutes, started_at)