Intuit Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Design an idempotent churn ETL pipeline
You must build a daily pipeline that produces month-end churn metrics (logo churn, gross revenue churn, net revenue retention) from streaming subscrip...
Compute churn and revenue churn in SQL
You receive monthly end-of-month subscription snapshots and must compute August-2025 churn metrics. Schema and sample data: Table: subscription_monthl...
Compute paid subscriber YoY counts by month
Write a single SQL query (PostgreSQL) that returns calendar-month counts of new paid subscribers starting from 2019-06-01 (inclusive) through the late...
Exclude free subscribers via anti-join
Extend your previous monthly new-subscriber + YoY query to exclude companies that ever received a free subscription, using an anti-join against Free_S...
Compute monthly new subscribers and YoY deltas
Write a single SQL query that returns monthly counts of new subscribers starting at 2019-06, plus year-over-year (same-month prior year) comparisons. ...