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

Refer Friends To Win BIG 🎁

Every friend that signs-up helps you access bonus questions and exclusive prizes!

Refer 3 Friends:

You Get 10 Bonus Statistics & SQL Interview Questions

Refer 10 Friends:

You Get Free Access to the Video Course Ace the Data Job Hunt ($30 Value)

Refer 50 Friends:

Book a 1-Hour, 1:1 Career Coaching Call with Nick Singh for FREE (Normally $200)

Your Progress

0%
Refer Friends To Unlock Rewards

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