SQL Practice Logo

SQLPractice Online

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)