Level 4 - Mid-LevelScenario-Based Questions
SLA Breach with Reopen Awareness
Support wants ticket_ids breached beyond 48h excluding tickets reopened in last 12h.
Schema Context
tickets(id, created_at, status), ticket_events(ticket_id, event_time, event_type)