SQL & Data Interview Questions

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

CompanyTitleCategoryDifficultyStatus
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

SQLHard
Snowflake icon

Snowflake

Marketing Touch Streak

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

Alibaba

Compressed Median

Premium

SQLHard
Airbnb icon

Airbnb

Average Vacant Days

Premium

SQLHard
UnitedHealth icon

UnitedHealth

Patient Support Analysis (Part 3)

SQLHard
UnitedHealth icon

UnitedHealth

Patient Support Analysis (Part 4)

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

SQLHard
Google icon

Google

Senior Managers

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

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