Routine~12min
The Orphan Tickets
203 open support tickets are assigned to an agent who resigned three months ago. They sit there. Customers are waiting. No one reassigned them because no one noticed.
Tables you'll query
agentstickets
What you'll learn
JOINsSELECT & Filtering