SQL & Data Interview Questions

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

CompanyTitleCategoryDifficultyStatus
Twitter icon

Twitter

Histogram of Tweets

SQLEasy
LinkedIn icon

LinkedIn

Data Science Skills

SQLEasy
Facebook icon

Facebook

Page With No Likes

SQLEasy
Tesla icon

Tesla

Unfinished Parts

SQLEasy
NY Times icon

NY Times

Laptop vs. Mobile Viewership

SQLEasy
Facebook icon

Facebook

Coin Fairness Test

StatisticsEasy
BCG Gamma icon

BCG Gamma

Precision/Recall Tradeoff

Machine LearningEasy
Facebook icon

Facebook

Average Post Hiatus (Part 1)

SQLEasy
Microsoft icon

Microsoft

Teams Power Users

SQLEasy
JPMorgan icon

JPMorgan

Two Consecutive Sixes

Premium🔒

ProbabilityEasy
Visa icon

Visa

4 Rolls To 4

StatisticsEasy
Capital One icon

Capital One

Base 13 Conversion

PythonEasy
ServiceNow icon

ServiceNow

Same Stripes

PythonEasy
Microsoft icon

Microsoft

Factorial Formula

PythonEasy
Amazon icon

Amazon

Intersection of Two Lists

PythonEasy
Spotify icon

Spotify

Another One

PythonEasy
Intuit icon

Intuit

Weakest Strong Link

PythonEasy
Google icon

Google

Fizz Buzz Sum

PythonEasy
Fintech icon

Fintech

Compound Interest

PythonEasy
Bloomberg icon

Bloomberg

Collatz Sequence Steps

Premium🔒

PythonEasy
TikTok icon

TikTok

Triangular Sum

PythonEasy
LinkedIn icon

LinkedIn

Duplicate Job Listings

SQLEasy
Robinhood icon

Robinhood

Cities With Completed Trades

SQLEasy
Apple icon

Apple

Contains Duplicate

PythonEasy
Facebook icon

Facebook

Straight Line

Premium🔒

PythonEasy
Palantir icon

Palantir

Roman to Integer

PythonEasy
Tesla icon

Tesla

Counting Letters In Numbers

PythonEasy
Amazon icon

Amazon

Average Review Ratings

SQLEasy
FAANG icon

FAANG

Well Paid Employees

SQLEasy
PayPal icon

PayPal

Final Account Balance

Premium🔒

SQLEasy
Workday icon

Workday

Is Anagram?

PythonEasy
Uber icon

Uber

Pascals Triangle

PythonEasy
Uber icon

Uber

Pascals Triangle (Part 2)

Premium🔒

PythonEasy
Intuit icon

Intuit

QuickBooks vs TurboTax

Premium🔒

SQLEasy
Facebook icon

Facebook

App Click-through Rate (CTR)

SQLEasy
TikTok icon

TikTok

Second Day Confirmation

SQLEasy
Spotify icon

Spotify

Is Palindrome

PythonEasy
Amazon icon

Amazon

Hundreds of Hypotheses

Premium🔒

StatisticsEasy
Google icon

Google

Probability of 7-Game Series

Premium🔒

ProbabilityEasy
IBM icon

IBM

IBM db2 Product Analytics

SQLEasy
Uber icon

Uber

Many Metropolitan Areas

Premium🔒

Machine LearningEasy
JPMorgan icon

JPMorgan

Cards Issued Difference

SQLEasy
Alibaba icon

Alibaba

Compressed Mean

SQLEasy
CVS Health icon

CVS Health

Pharmacy Analytics (Part 1)

SQLEasy
CVS Health icon

CVS Health

Pharmacy Analytics (Part 2)

SQLEasy
CVS Health icon

CVS Health

Pharmacy Analytics (Part 3)

SQLEasy
McKinsey icon

McKinsey

Assumptions of Linear Regression

Machine LearningEasy
Microsoft icon

Microsoft

Bootstrapping 101

Premium🔒

StatisticsEasy
UnitedHealth icon

UnitedHealth

Patient Support Analysis (Part 1)

SQLEasy
Netflix icon

Netflix

Lazy Movie Raters

ProbabilityMedium
Uber icon

Uber

User's Third Transaction

SQLMedium
FAANG icon

FAANG

Second Highest Salary

SQLMedium
Snapchat icon

Snapchat

Sending vs. Opening Snaps

SQLMedium
Twitter icon

Twitter

Tweets' Rolling Averages

SQLMedium
Akuna Capital icon

Akuna Capital

Consecutive Fives

StatisticsMedium
Amazon icon

Amazon

Highest-Grossing Items

SQLMedium
FAANG icon

FAANG

Top Three Salaries

SQLMedium
Google icon

Google

Sample Margin of Error

Premium🔒

StatisticsMedium
TikTok icon

TikTok

Signup Activation Rate

SQLMedium
Accenture icon

Accenture

Fill Missing Client Data

Premium🔒

SQLMedium
Spotify icon

Spotify

Spotify Streaming History

Premium🔒

SQLMedium
Microsoft icon

Microsoft

Mean, Median, Mode

Premium🔒

SQLMedium
CVS Health icon

CVS Health

Pharmacy Analytics (Part 4)

Premium🔒

SQLMedium
FAANG icon

FAANG

Longest Consecutive Sequence

PythonMedium
Fintech icon

Fintech

Looping Number

PythonMedium
FAANG icon

FAANG

Gift Card Satisfaction

PythonMedium
Salesforce icon

Salesforce

Matrix Rotation

PythonMedium
Adobe icon

Adobe

Clock-wise Matrix Rotation

PythonMedium
Google icon

Google

Min Amplitude

PythonMedium
Walmart icon

Walmart

Average Subarray

PythonMedium
Databricks icon

Databricks

k-Radius Average

PythonMedium
FAANG icon

FAANG

Idle GPU Days

PythonMedium
Swiggy icon

Swiggy

Hill Climbing

PythonMedium
Facebook icon

Facebook

Video Ads Insertion

PythonMedium
Walmart icon

Walmart

Spiral Matrix

PythonMedium
Palantir icon

Palantir

Integer to Roman

Premium🔒

PythonMedium
Walmart icon

Walmart

Frequently Purchased Pairs

Premium🔒

SQLMedium
FAANG icon

FAANG

Data Conference Attendees

PythonMedium
Facebook icon

Facebook

Bias-Variance Tradeoff

Premium🔒

Machine LearningMedium
Microsoft icon

Microsoft

Supercloud Customer

SQLMedium
Blackstone icon

Blackstone

Real Estate Modelling

Machine LearningMedium
Google icon

Google

Most Popular Integers

PythonMedium
Microsoft icon

Microsoft

Factorial Trailing Zeroes

Premium🔒

PythonMedium
Google icon

Google

Smallest Multiple

Premium🔒

PythonMedium
Blackstone icon

Blackstone

Generate Fractions

PythonMedium
D.E. Shaw icon

D.E. Shaw

Max Product of Three Numbers

PythonMedium
Amazon icon

Amazon

Two Sum

PythonMedium
Amazon icon

Amazon

Two Sum (Part 2)

PythonMedium
Amazon icon

Amazon

Two Sum (Part 3)

PythonMedium
Facebook icon

Facebook

Largest Prime Factor

Premium🔒

PythonMedium
Microsoft icon

Microsoft

Rotating Factorial

Premium🔒

PythonMedium
AQR icon

AQR

Pearson Correlation Coefficient

PythonMedium
Microsoft icon

Microsoft

Merge Conflicts

Premium🔒

PythonMedium
Akuna Capital icon

Akuna Capital

Largest Contiguous Subarray Sum

PythonMedium
D.E. Shaw icon

D.E. Shaw

Biased Coin?

StatisticsMedium
Google icon

Google

Odd and Even Measurements

SQLMedium
Zomato icon

Zomato

Swapped Food Delivery

SQLMedium
Amazon icon

Amazon

Coin Change

PythonMedium
Bloomberg icon

Bloomberg

FAANG Stock Min-Max (Part 1)

SQLMedium
Airbnb icon

Airbnb

Booking Referral Source

Premium🔒

SQLMedium
Facebook icon

Facebook

Uniform Distribution Median

Premium🔒

StatisticsMedium
Amazon icon

Amazon

User Shopping Sprees

SQLMedium
Uber icon

Uber

Fraud Detection Metrics

Premium🔒

Machine LearningMedium
Uber icon

Uber

2nd Ride Delay

Premium🔒

SQLMedium
Mu Sigma icon

Mu Sigma

Correlation Calculation

Premium🔒

StatisticsMedium
Walmart icon

Walmart

Histogram of Users and Purchases

SQLMedium
Google icon

Google

Google Maps Flagged UGC

Premium🔒

SQLMedium
Alibaba icon

Alibaba

Compressed Mode

SQLMedium
JPMorgan icon

JPMorgan

Card Launch Success

SQLMedium
Verizon icon

Verizon

International Call Percentage

SQLMedium
UnitedHealth icon

UnitedHealth

Patient Support Analysis (Part 2)

SQLMedium
LinkedIn icon

LinkedIn

Connection Request Spam

Machine LearningMedium
Facebook icon

Facebook

Active User Retention

SQLHard
Wayfair icon

Wayfair

Y-on-Y Growth Rate

SQLHard
Amazon icon

Amazon

Maximize Prime Item Inventory

SQLHard
Google icon

Google

Median Google Search Frequency

SQLHard
Facebook icon

Facebook

Advertiser Status

SQLHard
Apple icon

Apple

Word Search

PythonHard
Intuit icon

Intuit

Consecutive Filing Years

Premium🔒

SQLHard
Snowflake icon

Snowflake

Marketing Touch Streak

Premium🔒

SQLHard
McKinsey icon

McKinsey

3-Topping Pizzas

SQLHard
Uber icon

Uber

Geometric Random Variable

Premium🔒

StatisticsHard
Facebook icon

Facebook

Product vs. Square

StatisticsHard
Google icon

Google

Monotonic Sequence

Premium🔒

StatisticsHard
Robinhood icon

Robinhood

Modeling User Churn

Machine LearningHard
FAANG icon

FAANG

Department vs. Company Salary

SQLHard
Alibaba icon

Alibaba

Compressed Median

Premium🔒

SQLHard
Airbnb icon

Airbnb

Average Vacant Days

Premium🔒

SQLHard
UnitedHealth icon

UnitedHealth

Patient Support Analysis (Part 3)

Premium🔒

SQLHard
UnitedHealth icon

UnitedHealth

Patient Support Analysis (Part 4)

Premium🔒

SQLHard
Etsy icon

Etsy

Same Week Purchases

Premium🔒

SQLHard
Apple icon

Apple

Follow-Up Airpod Percentage

Premium🔒

SQLHard
Stripe icon

Stripe

Repeated Payments

SQLHard
Google icon

Google

Minimum of Two Uniform Variables

StatisticsHard
Microsoft icon

Microsoft

Frequentist vs. Bayesian

StatisticsHard
Amazon icon

Amazon

Most Expensive Purchase

Premium🔒

SQLEasy
Amazon icon

Amazon

Neural Networks Overfitting

Premium🔒

Machine LearningEasy
AQR icon

AQR

Correlated Predictors

Premium🔒

Machine LearningEasy
Visa icon

Visa

ApplePay Volume

Premium🔒

SQLEasy
Intel icon

Intel

Skewed Mean

Premium🔒

StatisticsEasy
Facebook icon

Facebook

Explain Confidence Intervals

Premium🔒

StatisticsEasy
Twitter icon

Twitter

Common A/B Testing Pitfalls

Premium🔒

StatisticsEasy
Johnson & Johnson icon

Johnson & Johnson

Experimental Design Blocking

Premium🔒

StatisticsEasy
Oracle icon

Oracle

Arithmetic Triplets

Premium🔒

PythonEasy
Amazon icon

Amazon

Missing Integer

Premium🔒

PythonEasy
Microsoft icon

Microsoft

Salary Inequity

Premium🔒

PythonEasy
Google icon

Google

Max Profit Trading Stocks

Premium🔒

PythonEasy
Accenture icon

Accenture

Subject Matter Experts

Premium🔒

SQLEasy
LinkedIn icon

LinkedIn

LinkedIn Power Creators (Part 1)

Premium🔒

SQLEasy
eBay icon

eBay

Highest Number of Products

Premium🔒

SQLEasy
Microsoft icon

Microsoft

Spare Server Capacity

Premium🔒

SQLEasy
Yelp icon

Yelp

Top Rated Businesses

Premium🔒

SQLEasy
Google icon

Google

Ad Campaign ROAS

Premium🔒

SQLEasy
Lyft icon

Lyft

Covariance vs. Correlation

Premium🔒

StatisticsEasy
PWC icon

PWC

Gradient Boosting vs. Random Forests

Premium🔒

Machine LearningEasy
NVIDIA icon

NVIDIA

Product Line Revenue

Premium🔒

SQLEasy
Point72 icon

Point72

Why Random Forest?

Premium🔒

Machine LearningEasy
Apple icon

Apple

Trade In Payouts

Premium🔒

SQLEasy
Amazon icon

Amazon

Shape of Amazon Orders Distribution

Premium🔒

StatisticsEasy
JPMorgan icon

JPMorgan

Satisfaction Bias

Premium🔒

StatisticsEasy
Microsoft icon

Microsoft

Statistical Power

Premium🔒

StatisticsEasy
Johnson & Johnson icon

Johnson & Johnson

P-Value Interpretation

Premium🔒

StatisticsEasy
Snowflake icon

Snowflake

Webinar Popularity

Premium🔒

SQLEasy
Microsoft icon

Microsoft

Boosting Example

Premium🔒

Machine LearningEasy
Airbnb icon

Airbnb

Improve Logistic Regression

Premium🔒

Machine LearningEasy
Uber icon

Uber

Central Limit Theorem

Premium🔒

StatisticsEasy
Oracle icon

Oracle

Who Made Quota?

Premium🔒

SQLEasy
Uber icon

Uber

Three Increasing Rolls

Premium🔒

ProbabilityEasy
Bloomberg icon

Bloomberg

Intersecting Chords

Premium🔒

ProbabilityEasy
Airbnb icon

Airbnb

Sample Size Needed

Premium🔒

StatisticsEasy
Accenture icon

Accenture

Model Diagnostics

Premium🔒

Machine LearningEasy
LinkedIn icon

LinkedIn

LinkedIn Power Creators (Part 2)

Premium🔒

SQLMedium
PayPal icon

PayPal

Unique Money Transfer Relationships

Premium🔒

SQLMedium
Twitter icon

Twitter

User Session Activity

Premium🔒

SQLMedium
Morgan Stanley icon

Morgan Stanley

Max of Two Dice Rolls

Premium🔒

StatisticsMedium
Goldman Sachs icon

Goldman Sachs

Noodle Loops

Premium🔒

StatisticsMedium
Uber icon

Uber

Distinct Values Drawn

Premium🔒

StatisticsMedium
Uber icon

Uber

Motivation For Cross-Validation

Premium🔒

Machine LearningMedium
Lyft icon

Lyft

Uniform Mean and Variance

Premium🔒

StatisticsMedium
Amazon icon

Amazon

Generative and Discriminative Models

Premium🔒

Machine LearningMedium
Spotify icon

Spotify

MLE Estimates

Premium🔒

StatisticsMedium
Citadel icon

Citadel

First Ace

Premium🔒

StatisticsMedium
Google icon

Google

Probability of Flipping Heads

Premium🔒

StatisticsMedium
Etsy icon

Etsy

First Transaction

Premium🔒

SQLMedium
Citadel icon

Citadel

All Six Sides

Premium🔒

StatisticsMedium
Microsoft icon

Microsoft

Information Gain and Entropy

Premium🔒

Machine LearningMedium
Facebook icon

Facebook

Email Table Transformation

Premium🔒

SQLMedium
Adobe icon

Adobe

Photoshop Revenue Analysis

Premium🔒

SQLMedium
Akuna Capital icon

Akuna Capital

Variance of Constants

Premium🔒

StatisticsMedium
Google icon

Google

Consulting Bench Time

Premium🔒

SQLMedium
Oracle icon

Oracle

Sales Team Compensation

Premium🔒

SQLMedium
Amazon icon

Amazon

Correlated Or Not?

Premium🔒

StatisticsMedium
Google icon

Google

Identifying Synonyms

Premium🔒

Machine LearningMedium
Apple icon

Apple

What Do You Mean?

Premium🔒

StatisticsMedium
Medtronic icon

Medtronic

PCA Ranges

Premium🔒

Machine LearningMedium
Salesforce icon

Salesforce

Average Deal Size (Part 2)

Premium🔒

SQLMedium
Two Sigma icon

Two Sigma

Normal Distribution Addition

Premium🔒

StatisticsMedium
Facebook icon

Facebook

Non Spam Friend Request

Premium🔒

StatisticsMedium
JPMorgan icon

JPMorgan

Separable Regression

Premium🔒

Machine LearningMedium
Uber icon

Uber

L1 and L2 Regularization

Premium🔒

Machine LearningMedium
Amazon icon

Amazon

Stochastic Gradient Descent

Premium🔒

Machine LearningMedium
Affirm icon

Affirm

Changing ROC Curve

Premium🔒

Machine LearningMedium
Amazon icon

Amazon

Cumulative Purchases by Product Type

Premium🔒

SQLMedium
Citadel icon

Citadel

Gaussian Naive Bayes vs. Logistic Regression

Premium🔒

Machine LearningMedium
Google icon

Google

Invalid Search Results

Premium🔒

SQLMedium
Salesforce icon

Salesforce

Lead Scoring Algorithm

Premium🔒

Machine LearningMedium
Stitch Fix icon

Stitch Fix

Repeat Purchases on Multiple Days

Premium🔒

SQLMedium
Amazon icon

Amazon

Convex Functions

Premium🔒

Machine LearningMedium
Visa icon

Visa

Point Estimator MSE

Premium🔒

StatisticsMedium
Accenture icon

Accenture

Compensation Outliers

Premium🔒

SQLMedium
Mu Sigma icon

Mu Sigma

Squared Variance

Premium🔒

StatisticsMedium
Bloomberg icon

Bloomberg

FAANG Stock Monthly Change (Part 2)

Premium🔒

SQLMedium
Bloomberg icon

Bloomberg

FAANG Underperforming Stocks (Part 3)

Premium🔒

SQLHard
Pinterest icon

Pinterest

User Concurrent Sessions

Premium🔒

SQLHard
Visa icon

Visa

Monthly Merchant Balance

Premium🔒

SQLHard
DoorDash icon

DoorDash

Bad Delivery Rate

Premium🔒

SQLHard
Facebook icon

Facebook

Page Recommendation

Premium🔒

SQLHard
Facebook icon

Facebook

Reactivated Users

Premium🔒

SQLHard
Google icon

Google

Senior Managers

Premium🔒

SQLHard
Facebook icon

Facebook

Event Friends Recommendation

Premium🔒

SQLHard
Airbnb icon

Airbnb

Matching Rental Amenities

Premium🔒

SQLHard
Facebook icon

Facebook

Weekly Churn Rates

Premium🔒

SQLHard
Two Sigma icon

Two Sigma

Continual Samples

Premium🔒

StatisticsHard
Tesla icon

Tesla

Exponential Draws

Premium🔒

StatisticsHard
Goldman Sachs icon

Goldman Sachs

Arbitrary Distribution

Premium🔒

StatisticsHard
Two Sigma icon

Two Sigma

Independent and Uncorrelated Random Variables

Premium🔒

StatisticsHard
Netflix icon

Netflix

MLE vs. MAP

Premium🔒

StatisticsHard
Uber icon

Uber

Random Bernoulli Generator

Premium🔒

StatisticsHard
Accenture icon

Accenture

Uniquely Staffed Consultants

Premium🔒

SQLHard
Amazon icon

Amazon

Server Utilization Time

SQLHard
Spotify icon

Spotify

Designing Discover Weekly

Premium🔒

Machine LearningHard
Google icon

Google

Unbiased & Consistent Estimators

Premium🔒

StatisticsHard
Apple icon

Apple

Surprising Decrease

Premium🔒

StatisticsHard
IBM icon

IBM

Entropy of Univariate Gaussian Random Variable

Premium🔒

Machine LearningHard
Morgan Stanley icon

Morgan Stanley

Normally Distributed MGF

Premium🔒

StatisticsHard
Google icon

Google

Blended Mean and Standard Deviation

Premium🔒

StatisticsHard
Citadel icon

Citadel

Covariance of X and Y

Premium🔒

StatisticsHard
TikTok icon

TikTok

Differentiability and Backprop

Premium🔒

Machine LearningHard

Your Progress

0%

Tags

Distinct and Unique Handling

23

Aggregate Functions

84

Set Operations

16

Data Type Conversion

29

Null Handling

7

Percentage Calculations

20

Array Functions

3

Ace the Data Science Interview

28

String Functions

5

Date-Time Functions

30

Control Flow Functions

1

User Behavior

14

Common Table Expressions (CTE) or Subquery

40

Window Functions

38

Data Generation Functions

1

Joins

12

Existence Check

9

Mathematical Functions

20

Conditional Expression

39

Arithmetic Operators

4

Top N Results

12

Conditional Logic

30

© 2025 DataLemur, Inc

Career Resources

Free 9-Day Data Interview Crash CourseFree SQL Tutorial for Data AnalyticsSQL Interview Cheat Sheet PDFUltimate SQL Interview GuideAce the Data Job Hunt Video CourseAce the Data Science InterviewBest Books for Data AnalystsSQL Squid Game