Complex~34min
The Star Agent
AGT-0077 has the highest CSAT on the team — 4.9 stars. Leadership wants to use them as a model for the others. Nobody has looked at what happens to their tickets after they mark them resolved.
Tables you'll query
agentsticketsticket_eventsratings
What you'll learn
CTEs (WITH clause)Window FunctionsJOINsDate & Time Functions