logo

SQL & Data Interview Questions

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

CompanyTitleCategoryDifficultyStatus

Twitter

Histogram of Tweets

SQLEasy

LinkedIn

Data Science Skills

SQLEasy

Facebook

Page With No Likes

SQLEasy

Tesla

Unfinished Parts

SQLEasy

New York Times

Laptop vs. Mobile Viewership

SQLEasy

Facebook

Coin Fairness Test

StatisticsEasy

BCG Gamma

Precision/Recall Tradeoff

Machine LearningEasy

Facebook

Average Post Hiatus (Part 1)

SQLEasy

Microsoft

Teams Power Users

SQLEasy

Visa

4 Rolls To 4

StatisticsEasy

Microsoft

Factorial Formula

PythonEasy

Google

Fizz Buzz Sum

PythonEasy

Amazon

Intersection of Two Lists

PythonEasy

Amazon

Missing Integer

PythonEasy

Linkedin

Duplicate Job Listings

SQLEasy

Robinhood

Cities With Completed Trades

SQLEasy

Apple

Contains Duplicate

PythonEasy

Microsoft

Salary Inequity

PythonEasy

Google

Max Profit Trading Stocks

PythonEasy

Amazon

Average Review Ratings

SQLEasy

Facebook

App Click-through Rate (CTR)

SQLEasy

TikTok

Second Day Confirmation

SQLEasy

IBM

IBM db2 Product Analytics

SQLEasy

JPMorgan Chase

Cards Issued Difference

SQLEasy

Alibaba

Compressed Mean

SQLEasy

CVS Health

Pharmacy Analytics (Part 1)

SQLEasy

CVS Health

Pharmacy Analytics (Part 2)

SQLEasy

CVS Health

Pharmacy Analytics (Part 3)

SQLEasy

McKinsey

Assumptions of Linear Regression

Machine LearningEasy

UnitedHealth

Patient Support Analysis (Part 1)

SQLEasy

Netflix

Lazy Movie Raters

ProbabilityMedium

Uber

User's Third Transaction

SQLMedium

FAANG

Second Highest Salary

SQLMedium

Snapchat

Sending vs. Opening Snaps

SQLMedium

Twitter

Tweets' Rolling Averages

SQLMedium

Akuna Capital

Consecutive Fives

StatisticsMedium

Amazon

Highest-Grossing Items

SQLMedium

FAANG

Top Three Salaries

SQLMedium

Spotify

Top 5 Artists

SQLMedium

TikTok

Signup Activation Rate

SQLMedium

Microsoft

Supercloud Customer

SQLMedium

Blackstone

Real Estate Modelling

Machine LearningMedium

Microsoft

Factorial Trailing Zeroes

PythonMedium

D.E. Shaw

Maximum Product of Three Numbers

PythonMedium

Amazon

Two Sum

PythonMedium

Facebook

Largest Prime Factor

PythonMedium

Google

Smallest Multiple

PythonMedium

AQR

Pearson Correlation Coefficient

PythonMedium

Microsoft

Merge Conflicts

PythonMedium

Akuna Capital

Largest Contiguous Subarray Sum

PythonMedium

D.E. Shaw

Biased Coin?

StatisticsMedium

Google

Odd and Even Measurements

SQLMedium

Walmart

Histogram of Users and Purchases

SQLMedium

Alibaba

Compressed Mode

SQLMedium

JPMorgan Chase

Card Launch Success

SQLMedium

Verizon

International Call Percentage

SQLMedium

UnitedHealth

Patient Support Analysis (Part 2)

SQLMedium

LinkedIn

Connection Request Spam

Machine LearningMedium

Facebook

Active User Retention

SQLHard

Wayfair

Y-on-Y Growth Rate

SQLHard

Amazon

Maximize Prime Item Inventory

SQLHard

Google

Median Google Search Frequency

SQLHard

Facebook

Advertiser Status

SQLHard

McKinsey

3-Topping Pizzas

SQLHard

Facebook

Product vs. Square

StatisticsHard

Robinhood

Modeling User Churn

Machine LearningHard

Stripe

Repeated Payments

SQLHard

Google

Minimum of Two Uniform Variables

StatisticsHard

Microsoft

Frequentist vs. Bayesian

StatisticsHard

Oracle

Who Made Quota?

SQLEasy

Amazon

Server Utilization Time

SQLHard

Zomato

Swapped Food Delivery

SQLMedium

FAANG

Department vs. Company Salary

SQLHard

FAANG

Well Paid Employees

SQLEasy

Bloomberg

FAANG Stock Min-Max (Part 1)

SQLMedium

Your Progress

0%

Refer Friends To Unlock More Questions

Tags

Percentage Calculations7

Joins11

Array Functions1

bball0

Date-Time Functions13

Mathematical Functions9

fun-run0

Aggregate Functions36

Ace the Data Science Interview15

Data Type Conversion13

Data Generation Functions0

Window Functions12

The-Office-SQL0

Set Operations2

Null Handling5

Conditional Expression17

Top N Results6

Control Flow Functions1

Arithmetic Operators3

Existence Check3

Conditional Logic11

Common Table Expressions (CTE) or Subquery17

String Functions2

Distinct and Unique Handling9

User Behavior6