Intuit·Data Scientist·Technical Phone Screen
- Given monthly end-of-month subscription snapshots, write an ANSI SQL query that computes logo churn count, logo churn rate, gross revenue churn, and net revenue retention for August 2025. Your query must handle users missing from one month via full outer join logic, deduplicate multiple snapshots per user per date using a load timestamp, and treat null MRR as zero.
- Using the provided sample data, what are the exact numeric outputs your SQL query would return for logo churn count, logo churn rate, gross revenue churn, and net revenue retention?
- How would your churn measurement logic change if you were working with transactional cancellation events instead of monthly snapshots, and what considerations around grace periods and partial-month proration would you need to address?
“This is where I spent most of my time and still felt shaky at the end.”