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
Investigate this case →