Top 50
Topic roadmap
Updated weekly · Last refresh Nov 1

Top 50 case study Interview Questions

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

50questions
~10htotal time
241companies 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. 17 questions · ~213 min
AI/ML Case Study TheoryHard
Practice
Recently asked

Build a SQL evidence summary comparing model evaluation metrics, prior runs, and performance rank.

Lag/LeadCTEscase studyC3 AI
SQL and Experiment Case RoundsMedium
Practice
Recently asked

Aggregate Uber product performance by city, then rank products by completed trips and completion rate.

JoinsCTEscase studyUber
SQL, Pandas, and Case Study Live CodingMedium
Practice

Summarize January pin activity and saves per creator while retaining creators whose qualifying pins received no saves.

pandasJoinsData ManipulationPinterest
End-to-End Take-Home Case StudyHard
Practice

Prepare modeling records, calculate segment-level error metrics, compare model versions, and summarize management assumptions with PostgreSQL.

data preparationcase studydata validationRobinhood
Case Study With SQLMedium
Practice
Recently asked

Analyze customer transaction activity with joins, aggregations, and conditional classification.

Joinscase studyCase WhenCapital One
Case Study Interview and SQL Live CodingMedium
Practice
Recently asked

Demonstrate a structured SQL approach using joins, CTEs, aggregation, and month-over-month comparisons.

Lag/Leadcase studycomplex queriesDoorDash
New City Delivery Case With ScootersMedium
Practice
Recently asked

Aggregate scooter ride activity by zone and day to identify operational demand, cancellations, wait times, and availability.

business problemcase studyCase WhenDoorDash
AI/ML Theory Behind SolutionsHard
Practice
Recently asked

Select the strongest improving AI/ML solution per case using validation history, reproducibility, and documented theory evidence.

Lag/LeadCTEscase studyC3.ai
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
Behavioral & Leadership11 questions · ~138 min
More Behavioral & Leadership questions with a free account
3
Execution13 questions · ~163 min
More Execution questions with a free account
4
Strategy3 questions · ~38 min
More Strategy questions with a free account
5
More topics6 questions · ~75 min
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.