SQL & Data Interview Questions

Practice the most common SQL, Statistics, ML, and Python questions asked in FAANG Data Science & Data Analyst interviews!

Company	Title	Category	Difficulty
Twitter	Histogram of Tweets	SQL	Easy
LinkedIn	Data Science Skills	SQL	Easy
Facebook	Page With No Likes	SQL	Easy
Tesla	Unfinished Parts	SQL	Easy
NY Times	Laptop vs. Mobile Viewership	SQL	Easy
Facebook	Coin Fairness Test	Statistics	Easy
BCG Gamma	Precision/Recall Tradeoff	Machine Learning	Easy
Facebook	Average Post Hiatus (Part 1)	SQL	Easy
Microsoft	Teams Power Users	SQL	Easy
Visa	4 Rolls To 4	Statistics	Easy
Capital One	Base 13 Conversion	Python	Easy
Microsoft	Factorial Formula	Python	Easy
Google	Fizz Buzz Sum	Python	Easy
Palantir	Roman to Integer	Python	Easy
Amazon	Intersection of Two Lists	Python	Easy
TikTok	Triangular Sum	Python	Easy
LinkedIn	Duplicate Job Listings	SQL	Easy
Robinhood	Cities With Completed Trades	SQL	Easy
Apple	Contains Duplicate	Python	Easy
Tesla	Counting Letters In Numbers	Python	Easy
Amazon	Average Review Ratings	SQL	Easy
FAANG	Well Paid Employees	SQL	Easy
Uber	Pascals Triangle	Python	Easy
Facebook	App Click-through Rate (CTR)	SQL	Easy
TikTok	Second Day Confirmation	SQL	Easy
Spotify	Is Palindrome	Python	Easy
IBM	IBM db2 Product Analytics	SQL	Easy
JPMorgan	Cards Issued Difference	SQL	Easy
Alibaba	Compressed Mean	SQL	Easy
CVS Health	Pharmacy Analytics (Part 1)	SQL	Easy
CVS Health	Pharmacy Analytics (Part 2)	SQL	Easy
CVS Health	Pharmacy Analytics (Part 3)	SQL	Easy
McKinsey	Assumptions of Linear Regression	Machine Learning	Easy
Oracle	Arithmetic Triplets	Python	Easy
UnitedHealth	Patient Support Analysis (Part 1)	SQL	Easy
Netflix	Lazy Movie Raters	Probability	Medium
Uber	User's Third Transaction	SQL	Medium
FAANG	Second Highest Salary	SQL	Medium
Snapchat	Sending vs. Opening Snaps	SQL	Medium
Twitter	Tweets' Rolling Averages	SQL	Medium
Akuna Capital	Consecutive Fives	Statistics	Medium
Amazon	Highest-Grossing Items	SQL	Medium
FAANG	Top Three Salaries	SQL	Medium
Spotify	Top 5 Artists	SQL	Medium
TikTok	Signup Activation Rate	SQL	Medium
FAANG	Gift Card Satisfaction	Python	Medium
Salesforce	Matrix Rotation	Python	Medium
Adobe	Clock-wise Matrix Rotation	Python	Medium
Google	Min Amplitude	Python	Medium
Walmart	Average Subarray	Python	Medium
Swiggy	Hill Climbing	Python	Medium
Facebook	Video Ads Insertion	Python	Medium
Palantir	Integer to Roman	Python	Medium
FAANG	Data Conference Attendees	Python	Medium
Microsoft	Supercloud Customer	SQL	Medium
Blackstone	Real Estate Modelling	Machine Learning	Medium
D.E. Shaw	Max Product of Three Numbers	Python	Medium
Amazon	Two Sum	Python	Medium
Microsoft	Rotating Factorial	Python	Medium
AQR	Pearson Correlation Coefficient	Python	Medium
Akuna Capital	Largest Contiguous Subarray Sum	Python	Medium
D.E. Shaw	Biased Coin?	Statistics	Medium
Google	Odd and Even Measurements	SQL	Medium
Zomato	Swapped Food Delivery	SQL	Medium
Amazon	Coin Change	Python	Medium
Bloomberg	FAANG Stock Min-Max (Part 1)	SQL	Medium
Amazon	User Shopping Sprees	SQL	Medium
Walmart	Histogram of Users and Purchases	SQL	Medium
Alibaba	Compressed Mode	SQL	Medium
JPMorgan	Card Launch Success	SQL	Medium
Verizon	International Call Percentage	SQL	Medium
UnitedHealth	Patient Support Analysis (Part 2)	SQL	Medium
LinkedIn	Connection Request Spam	Machine Learning	Medium
Facebook	Active User Retention	SQL	Hard
Wayfair	Y-on-Y Growth Rate	SQL	Hard
Amazon	Maximize Prime Item Inventory	SQL	Hard
Google	Median Google Search Frequency	SQL	Hard
Facebook	Advertiser Status	SQL	Hard
Apple	Word Search	Python	Hard
McKinsey	3-Topping Pizzas	SQL	Hard
Facebook	Product vs. Square	Statistics	Hard
Robinhood	Modeling User Churn	Machine Learning	Hard
FAANG	Department vs. Company Salary	SQL	Hard
Stripe	Repeated Payments	SQL	Hard
Google	Minimum of Two Uniform Variables	Statistics	Hard
Microsoft	Frequentist vs. Bayesian	Statistics	Hard
Amazon	Server Utilization Time	SQL	Hard

SQL & Data Interview Questions

Career Resources

Support

Interview Questions