Complex~39min
The Bonus Cliff
Five reps, four quarters, 100% quota attainment every time. Sales leadership calls it a well-oiled machine. Finance noticed that 6-month churn is spiking. Pull the deal data and tell them why.
Tables you'll query
repsdealsquarterly_targetsdeal_activities
What you'll learn
CTEs (WITH clause)Window FunctionsDate & Time FunctionsAggregations & GROUP BY