Top 50
Topic roadmap
Updated weekly · Last refresh Sep 13

Top 50 Retention Interview Questions

The most frequently asked Retention questions across all roles and companies, ranked by real interview frequency. Updated daily.

50questions
~9htotal time
897companies covered
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 10 questions · ~105 min
SQL Month-Over-Month RetentionMedium
Practice
Recently asked

Calculate monthly active-user retention for Unity Ads using CTEs, joins, date truncation, and conditional aggregation.

Window FunctionsRetentiontransactionsInsurifyUnityDoorDash
7-Day Rider Retention in NYCHard
Practice

Compute 7-day NYC rider retention by signup cohort using joins, CTEs, date filters, and distinct retained-user aggregation.

Window FunctionsRetentionRunning TotalsUberAsana
SQL for MoM RetentionHard
Practice

Calculate cohort month-over-month retention for Thumbtack service professionals using CTEs, date truncation, joins, and aggregation.

Window FunctionsDate FunctionsRetentionThumbtack
Month-over-Month Creator RetentionMedium
Practice
Recently asked

Calculate monthly active-creator retention from TikTok video interactions using date-based cohorts and aggregation.

Window FunctionsDate FunctionsRetentionTikTok
First-Order Item Then ChurnMedium
Practice
Recently asked

Find customers whose first order included a Big Mac but who have not purchased in the last 30 days.

SubqueriesDate FunctionsRetentionMcdonald'S Global Office In India
SQL for Retention MetricsMedium
Practice
Recently asked

Calculate daily active Waymo One riders and seven-day retention using aggregation, joins, and date comparisons.

Date FunctionsRetentionJoinsWaymo
MoM Retention for Student ProfilesMedium
Practice

Calculate month-over-month retention for active Handshake student profiles using monthly aggregation and joins.

Date FunctionsRetentionJoinsHandshake - stryder
Retention Query for AR LensesMedium
Practice

Calculate monthly Snapchat AR lens retention by comparing each month's active users with the prior month's users.

Date FunctionsRetentionJoinsSnap
More SQL & Data Manipulation questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
2
Metrics35 questions · ~367 min
More Metrics questions with a free account
3
More topics5 questions · ~52 min
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.