Cold Case~70min
The Year-End Magic
Every December for three consecutive years, 15 deals close in the final 3 days of the month. In January, an average of 9 are reversed. Bonuses were paid on the December numbers.
Tables you'll query
dealsdeal_stage_historysales_repsbonuses
What you'll learn
Window FunctionsCTEs (WITH clause)SubqueriesDate & Time FunctionsAggregations & GROUP BY