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

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