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

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
NY Times icon

NY Times

Laptop vs. Mobile Viewership

SQLEasy
Facebook icon

Facebook

Average Post Hiatus (Part 1)

SQLEasy
Microsoft icon

Microsoft

Teams Power Users

SQLEasy
LinkedIn icon

LinkedIn

Duplicate Job Listings

SQLEasy
Robinhood icon

Robinhood

Cities With Completed Trades

SQLEasy
Amazon icon

Amazon

Average Review Ratings

SQLEasy
FAANG icon

FAANG

Well Paid Employees

SQLEasy
PayPal icon

PayPal

Final Account Balance

Premium🔒

SQLEasy
Intuit icon

Intuit

QuickBooks vs TurboTax

Premium🔒

SQLEasy
Facebook icon

Facebook

App Click-through Rate (CTR)

SQLEasy
TikTok icon

TikTok

Second Day Confirmation

SQLEasy
IBM icon

IBM

IBM db2 Product Analytics

SQLEasy
JPMorgan icon

JPMorgan

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

UnitedHealth

Patient Support Analysis (Part 1)

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

Amazon

Highest-Grossing Items

SQLMedium
FAANG icon

FAANG

Top Three Salaries

SQLMedium
TikTok icon

TikTok

Signup Activation Rate

SQLMedium
Accenture icon

Accenture

Fill Missing Client Data

Premium🔒

SQLMedium
Spotify icon

Spotify

Spotify Streaming History

Premium🔒

SQLMedium
Microsoft icon

Microsoft

Mean, Median, Mode

Premium🔒

SQLMedium
CVS Health icon

CVS Health

Pharmacy Analytics (Part 4)

Premium🔒

SQLMedium
Walmart icon

Walmart

Frequently Purchased Pairs

Premium🔒

SQLMedium
Microsoft icon

Microsoft

Supercloud Customer

SQLMedium
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
Airbnb icon

Airbnb

Booking Referral Source

Premium🔒

SQLMedium
Amazon icon

Amazon

User Shopping Sprees

SQLMedium
Uber icon

Uber

2nd Ride Delay

Premium🔒

SQLMedium
Walmart icon

Walmart

Histogram of Users and Purchases

SQLMedium
Google icon

Google

Google Maps Flagged UGC

Premium🔒

SQLMedium
Alibaba icon

Alibaba

Compressed Mode

SQLMedium
JPMorgan icon

JPMorgan

Card Launch Success

SQLMedium
Verizon icon

Verizon

International Call Percentage

SQLMedium
UnitedHealth icon

UnitedHealth

Patient Support Analysis (Part 2)

SQLMedium
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
Intuit icon

Intuit

Consecutive Filing Years

Premium🔒

SQLHard
Snowflake icon

Snowflake

Marketing Touch Streak

Premium🔒

SQLHard
McKinsey icon

McKinsey

3-Topping Pizzas

SQLHard
FAANG icon

FAANG

Department vs. Company Salary

SQLHard
Alibaba icon

Alibaba

Compressed Median

Premium🔒

SQLHard
Airbnb icon

Airbnb

Average Vacant Days

Premium🔒

SQLHard
UnitedHealth icon

UnitedHealth

Patient Support Analysis (Part 3)

Premium🔒

SQLHard
UnitedHealth icon

UnitedHealth

Patient Support Analysis (Part 4)

Premium🔒

SQLHard
Etsy icon

Etsy

Same Week Purchases

Premium🔒

SQLHard
Apple icon

Apple

Follow-Up Airpod Percentage

Premium🔒

SQLHard
Stripe icon

Stripe

Repeated Payments

SQLHard
Amazon icon

Amazon

Most Expensive Purchase

Premium🔒

SQLEasy
Visa icon

Visa

ApplePay Volume

Premium🔒

SQLEasy
Accenture icon

Accenture

Subject Matter Experts

Premium🔒

SQLEasy
LinkedIn icon

LinkedIn

LinkedIn Power Creators (Part 1)

Premium🔒

SQLEasy
eBay icon

eBay

Highest Number of Products

Premium🔒

SQLEasy
Microsoft icon

Microsoft

Spare Server Capacity

Premium🔒

SQLEasy
Yelp icon

Yelp

Top Rated Businesses

Premium🔒

SQLEasy
Google icon

Google

Ad Campaign ROAS

Premium🔒

SQLEasy
NVIDIA icon

NVIDIA

Product Line Revenue

Premium🔒

SQLEasy
Apple icon

Apple

Trade In Payouts

Premium🔒

SQLEasy
Snowflake icon

Snowflake

Webinar Popularity

Premium🔒

SQLEasy
Oracle icon

Oracle

Who Made Quota?

Premium🔒

SQLEasy
LinkedIn icon

LinkedIn

LinkedIn Power Creators (Part 2)

Premium🔒

SQLMedium
PayPal icon

PayPal

Unique Money Transfer Relationships

Premium🔒

SQLMedium
Twitter icon

Twitter

User Session Activity

Premium🔒

SQLMedium
Etsy icon

Etsy

First Transaction

Premium🔒

SQLMedium
Facebook icon

Facebook

Email Table Transformation

Premium🔒

SQLMedium
Adobe icon

Adobe

Photoshop Revenue Analysis

Premium🔒

SQLMedium
Google icon

Google

Consulting Bench Time

Premium🔒

SQLMedium
Oracle icon

Oracle

Sales Team Compensation

Premium🔒

SQLMedium
Salesforce icon

Salesforce

Average Deal Size (Part 2)

Premium🔒

SQLMedium
Amazon icon

Amazon

Cumulative Purchases by Product Type

Premium🔒

SQLMedium
Google icon

Google

Invalid Search Results

Premium🔒

SQLMedium
Stitch Fix icon

Stitch Fix

Repeat Purchases on Multiple Days

Premium🔒

SQLMedium
Accenture icon

Accenture

Compensation Outliers

Premium🔒

SQLMedium
Bloomberg icon

Bloomberg

FAANG Stock Monthly Change (Part 2)

Premium🔒

SQLMedium
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

Premium🔒

SQLHard
Google icon

Google

Senior Managers

Premium🔒

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

Accenture

Uniquely Staffed Consultants

Premium🔒

SQLHard
Amazon icon

Amazon

Server Utilization Time

SQLHard

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

© 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