Complex~36min
The Seasonal Employee
Store #7 has the best numbers in the region. Regional manager is showcasing it as a model. Three contract employees left two months ago. Nobody looked at what happened after.
Tables you'll query
storesemployeessales_transactions
What you'll learn
Window FunctionsCTEs (WITH clause)Date & Time FunctionsJOINs