SQL & Data Interview Questions

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

CompanyTitleCategoryDifficultyStatus
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
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

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