Complex~35min
The Silent Downgrade Wave
5 accounts had active_seats decline in each of the 3 months immediately before they cancelled — a slow bleed no single-month alert ever caught because each drop was small. 8 education-vertical accounts also show a multi-month seat decline, but that's a normal summer dip that fully recovers by September, and none of them ever actually cancel.
Tables you'll query
accountsmonthly_active_seatscancellations
What you'll learn
CTEs (WITH clause)Window FunctionsDate & Time Functions