SQL & Data Interview Questions

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

CompanyTitleCategoryDifficultyStatus
JPMorgan Chase icon

JPMorgan Chase

Data Science Skills

SQLEasy
FAANG icon

FAANG

Page With No Likes

SQLEasy
CVS Health icon

CVS Health

Laptop vs. Mobile Viewership

SQLEasy
Snowflake icon

Snowflake

Coin Fairness Test

StatisticsEasy
Uber icon

Uber

Precision/Recall Tradeoff

Machine LearningEasy
Medtronic icon

Medtronic

Average Post Hiatus (Part 1)

SQLEasy
Intuit icon

Intuit

Teams Power Users

SQLEasy
NVIDIA icon

NVIDIA

4 Rolls To 4

StatisticsEasy
Twitter icon

Twitter

Base 13 Conversion

PythonMedium
Morgan Stanley icon

Morgan Stanley

Same Stripes

PythonEasy
Snapchat icon

Snapchat

Factorial Formula

PythonEasy
Groupon icon

Groupon

Intersection of Two Lists

PythonEasy
ServiceNow icon

ServiceNow

Another One

PythonEasy
Amazon icon

Amazon

Weakest Strong Link

PythonEasy
NY Times icon

NY Times

Fizz Buzz Sum

PythonEasy
NVIDIA icon

NVIDIA

Compound Interest

PythonEasy
Salesforce icon

Salesforce

Triangular Sum

PythonEasy
BCG Gamma icon

BCG Gamma

Duplicate Job Listings

SQLEasy
Groupon icon

Groupon

Cities With Completed Trades

SQLEasy
Etsy icon

Etsy

Contains Duplicate

PythonEasy
eBay icon

eBay

Roman to Integer

PythonEasy
Capital One icon

Capital One

Counting Letters In Numbers

PythonEasy
FAANG icon

FAANG

Average Review Ratings

SQLEasy
Affirm icon

Affirm

Well Paid Employees

SQLEasy
Bloomberg icon

Bloomberg

Pascals Triangle

PythonEasy
Intel icon

Intel

App Click-through Rate (CTR)

SQLEasy
Goldman Sachs icon

Goldman Sachs

Second Day Confirmation

SQLEasy
Goodreads Books icon

Goodreads Books

Is Palindrome

PythonEasy
Amazon icon

Amazon

IBM db2 Product Analytics

SQLEasy
Stripe icon

Stripe

Cards Issued Difference

SQLEasy
Adobe icon

Adobe

Compressed Mean

SQLEasy
Swiggy icon

Swiggy

Pharmacy Analytics (Part 1)

SQLEasy
Uber icon

Uber

Pharmacy Analytics (Part 2)

SQLEasy
LinkedIn icon

LinkedIn

Pharmacy Analytics (Part 3)

SQLEasy
PayPal icon

PayPal

Assumptions of Linear Regression

Machine LearningEasy
PayPal icon

PayPal

Patient Support Analysis (Part 1)

SQLEasy
Lyft icon

Lyft

Lazy Movie Raters

ProbabilityMedium
Pinterest icon

Pinterest

User's Third Transaction

SQLMedium
NVIDIA icon

NVIDIA

Second Highest Salary

SQLMedium
Pinterest icon

Pinterest

Sending vs. Opening Snaps

SQLMedium
Etsy icon

Etsy

Tweets' Rolling Averages

SQLMedium
Airbnb icon

Airbnb

Consecutive Fives

StatisticsMedium
D.E. Shaw icon

D.E. Shaw

Highest-Grossing Items

SQLMedium
Goodreads Books icon

Goodreads Books

Top Three Salaries

SQLMedium
Salesforce icon

Salesforce

Top 5 Artists

SQLMedium
Airbnb icon

Airbnb

Signup Activation Rate

SQLMedium
IBM icon

IBM

Looping Number

PythonMedium
Tesla icon

Tesla

Gift Card Satisfaction

PythonMedium
JPMorgan Chase icon

JPMorgan Chase

Matrix Rotation

PythonMedium
Stripe icon

Stripe

Clock-wise Matrix Rotation

PythonMedium
Walmart icon

Walmart

Min Amplitude

PythonMedium
Two Sigma icon

Two Sigma

Average Subarray

PythonMedium
Databricks icon

Databricks

k-Radius Average

PythonMedium
Salesforce icon

Salesforce

Idle GPU Days

PythonMedium
Microsoft icon

Microsoft

Hill Climbing

PythonMedium
Blackstone icon

Blackstone

Video Ads Insertion

PythonMedium
Blackstone icon

Blackstone

Spiral Matrix

PythonMedium
McKinsey icon

McKinsey

Integer to Roman

PythonMedium
Reddit icon

Reddit

Data Conference Attendees

PythonMedium
Robinhood icon

Robinhood

Supercloud Customer

SQLMedium
Stripe icon

Stripe

Real Estate Modelling

Machine LearningMedium
IBM icon

IBM

Generate Fractions

PythonMedium
Amazon icon

Amazon

Max Product of Three Numbers

PythonMedium
Adobe icon

Adobe

Two Sum

PythonMedium
Apple icon

Apple

Rotating Factorial

PythonMedium
Akuna Capital icon

Akuna Capital

Pearson Correlation Coefficient

PythonMedium
D.E. Shaw icon

D.E. Shaw

Largest Contiguous Subarray Sum

PythonMedium
Akuna Capital icon

Akuna Capital

Biased Coin?

StatisticsMedium
McKinsey icon

McKinsey

Odd and Even Measurements

SQLMedium
Airbnb icon

Airbnb

Swapped Food Delivery

SQLMedium
D.E. Shaw icon

D.E. Shaw

Coin Change

PythonMedium
Oracle icon

Oracle

FAANG Stock Min-Max (Part 1)

SQLMedium
Palantir icon

Palantir

User Shopping Sprees

SQLMedium
Apple icon

Apple

Histogram of Users and Purchases

SQLMedium
TikTok icon

TikTok

Compressed Mode

SQLMedium
Uber icon

Uber

Card Launch Success

SQLMedium
Uber icon

Uber

International Call Percentage

SQLMedium
Airbnb icon

Airbnb

Patient Support Analysis (Part 2)

SQLMedium
NVIDIA icon

NVIDIA

Connection Request Spam

Machine LearningMedium
Palantir icon

Palantir

Active User Retention

SQLEasy
FAANG icon

FAANG

Y-on-Y Growth Rate

SQLHard
Instacart icon

Instacart

Maximize Prime Item Inventory

SQLHard
Uber icon

Uber

Median Google Search Frequency

SQLHard
Accenture icon

Accenture

Advertiser Status

SQLHard
Snapchat icon

Snapchat

Word Search

PythonHard
McKinsey icon

McKinsey

3-Topping Pizzas

SQLHard
Snapchat icon

Snapchat

Product vs. Square

StatisticsHard
Snowflake icon

Snowflake

Modeling User Churn

Machine LearningHard
JPMorgan icon

JPMorgan

Department vs. Company Salary

SQLHard
Point72 icon

Point72

Repeated Payments

SQLHard
PWC icon

PWC

Minimum of Two Uniform Variables

StatisticsHard
Goldman Sachs icon

Goldman Sachs

Frequentist vs. Bayesian

StatisticsHard
Apple icon

Apple

FAANG Underperforming Stocks (Part 3)

SQLHard
Morgan Stanley icon

Morgan Stanley

Server Utilization Time

SQLHard
Groupon icon

Groupon

Manufacturing Plant (Pandas)

PandasMedium
Uber icon

Uber

Movies By Decade

PySparkEasy
Spotify icon

Spotify

Manufacturing Plant (Polars)

PolarsMedium
Mu Sigma icon

Mu Sigma

TEST (FAANG Stock Min-Max (Part 1))

SQLEasy

test pandas

PandasEasy

Your Progress

0%

Tags

Percentage Calculations

2

Python test tag

1

Joins

2

Array Functions

2

Date-Time Functions

1

Mathematical Functions

2

Aggregate Functions

2

Ace the Data Science Interview

2

Data Type Conversion

2

Data Generation Functions

2

Window Functions

2

Set Operations

2

Null Handling

2

Conditional Expression

2

Test tag 2

1

Top N Results

2

Control Flow Functions

2

Arithmetic Operators

2

Existence Check

2

Conditional Logic

2

Common Table Expressions (CTE) or Subquery

2

TEST TAG

3

String Functions

2

Distinct and Unique Handling

2

User Behavior

2

© 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