Cold Case~70min
The Acquisition Illusion
Revenue is up 30% YoY. New user numbers are strong. The board is happy. The CFO quietly asks you to check one thing: what happens to those users after 90 days.
Tables you'll query
userspaymentscohort_metricssubscription_events
What you'll learn
Window FunctionsCTEs (WITH clause)SubqueriesDate & Time FunctionsAggregations & GROUP BY