Routine~14min
The Ignored SLA
The support dashboard reports an 89% SLA compliance rate. But when you calculate actual resolution times from the raw data, the number looks very different. A batch-close script marked 38 tickets as resolved without checking whether the SLA window had passed. The sla_breached flag was never set on them.
Tables you'll query
tickets
What you'll learn
SELECT & FilteringDate & Time Functions