SQL & Data Interview Questions

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

CompanyTitleCategoryDifficulty
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
New York Times icon

New York 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
Visa icon

Visa

4 Rolls To 4

StatisticsEasy
Microsoft icon

Microsoft

Factorial Formula

PythonEasy
Google icon

Google

Fizz Buzz Sum

PythonEasy
Palantir icon

Palantir

Roman to Integer

PythonEasy
Amazon icon

Amazon

Intersection of Two Lists

PythonEasy
Bloomberg icon

Bloomberg

Collatz Sequence Steps

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

PythonEasy
Capital One icon

Capital One

Base 13 Conversion

PythonEasy
Amazon icon

Amazon

Average Review Ratings

SQLEasy
FAANG icon

FAANG

Well Paid Employees

SQLEasy
Uber icon

Uber

Pascals Triangle

PythonEasy
Facebook icon

Facebook

App Click-through Rate (CTR)

SQLEasy
TikTok icon

TikTok

Second Day Confirmation

SQLEasy
Spotify icon

Spotify

Is Palindrome

PythonEasy
IBM icon

IBM

IBM db2 Product Analytics

SQLEasy
JPMorgan Chase icon

JPMorgan Chase

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

Oracle

Arithmetic Triplets

PythonEasy
UnitedHealth icon

UnitedHealth

Patient Support Analysis (Part 1)

SQLEasy
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
Spotify icon

Spotify

Top 5 Artists

SQLMedium
TikTok icon

TikTok

Signup Activation Rate

SQLMedium
Stripe icon

Stripe

Maximum Sum of a Matrix

PythonMedium
Palantir icon

Palantir

Integer to Roman

PythonMedium
Microsoft icon

Microsoft

Supercloud Customer

SQLMedium
Blackstone icon

Blackstone

Real Estate Modelling

Machine LearningMedium
D.E. Shaw icon

D.E. Shaw

Maximum Product of Three Numbers

PythonMedium
Amazon icon

Amazon

Two Sum

PythonMedium
Facebook icon

Facebook

Largest Prime Factor

PythonMedium
Google icon

Google

Smallest Multiple

PythonMedium
AQR icon

AQR

Pearson Correlation Coefficient

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

Bloomberg

FAANG Stock Min-Max (Part 1)

SQLMedium
Walmart icon

Walmart

Histogram of Users and Purchases

SQLMedium
Alibaba icon

Alibaba

Compressed Mode

SQLMedium
JPMorgan Chase icon

JPMorgan Chase

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

McKinsey

3-Topping Pizzas

SQLHard
Facebook icon

Facebook

Product vs. Square

StatisticsHard
Robinhood icon

Robinhood

Modeling User Churn

Machine LearningHard
FAANG icon

FAANG

Department vs. Company Salary

SQLHard
Stripe icon

Stripe

Repeated Payments

SQLHard
Google icon

Google

Minimum of Two Uniform Variables

StatisticsHard
Microsoft icon

Microsoft

Frequentist vs. Bayesian

StatisticsHard
Amazon icon

Amazon

Server Utilization Time

SQLHard

Your Progress

0%

Easy

0/35

Medium

0/30

Hard

0/13

Tags

Percentage Calculations

7

Joins

10

Array Functions

1

bball

0

Date-Time Functions

13

Mathematical Functions

9

fun-run

0

Aggregate Functions

35

Ace the Data Science Interview

15

Data Type Conversion

13

Data Generation Functions

0

Window Functions

12

The-Office-SQL

0

Set Operations

2

Null Handling

5

Conditional Expression

16

Top N Results

6

Control Flow Functions

1

Arithmetic Operators

3

Existence Check

3

Conditional Logic

10

Common Table Expressions (CTE) or Subquery

17

String Functions

2

Distinct and Unique Handling

9

User Behavior

6

© 2024 DataLemur, Inc

Career Resources

Free 9-Day Data Interview Crash CourseFree SQL Tutorial for Data AnalyticsUltimate SQL Interview GuideAce the Data Job Hunt Video CourseAce the Data Science InterviewBest Books for Data Analysts