Intuit Data Manipulation (SQL/Python) Interview Questions
Practice the exact questions companies are asking right now.
Compute monthly signups, conversion, and YoY growth
You work at a subscription company and are given a user-level table. Table company_users - id (INT, PK) — user/customer id - signup_date (DATE) — date...
Pivot daily users and revenue by platform
You are given transaction-level data and need daily aggregates by platform. Input (Pandas DataFrame) df with columns: - file_date (DATE or string pars...
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. ...