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

Base 13 Conversion

PythonMedium
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
Groupon icon

Groupon

Manufacturing Plant (Pandas)

PandasMedium
Spotify icon

Spotify

Manufacturing Plant (Polars)

PolarsMedium

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