SQL Interview Questions

Writing SQL queries is KEY to Acing the Data Science Interview, but if you want to go beyond SQL join our FREE
9-Day Interview Crash Course! (which covers Probability, Statistics, ML, Coding, & Product-Sense).

CompanyTitleDifficulty
Twitter icon

Twitter

Histogram of Tweets

Easy
LinkedIn icon

LinkedIn

Data Science Skills

Easy
Facebook icon

Facebook

Page With No Likes

Easy
Tesla icon

Tesla

Unfinished Parts

Easy
New York Times icon

New York Times

Laptop vs. Mobile Viewership

Easy
Facebook icon

Facebook

Average Post Hiatus (Part 1)

Easy
Microsoft icon

Microsoft

Teams Power Users

Easy
LinkedIn icon

LinkedIn

Duplicate Job Listings

Easy
Robinhood icon

Robinhood

Cities With Completed Trades

Easy
Amazon icon

Amazon

Average Review Ratings

Easy
FAANG icon

FAANG

Well Paid Employees

Easy
Facebook icon

Facebook

App Click-through Rate (CTR)

Easy
TikTok icon

TikTok

Second Day Confirmation

Easy
IBM icon

IBM

IBM db2 Product Analytics

Easy
JPMorgan Chase icon

JPMorgan Chase

Cards Issued Difference

Easy
Alibaba icon

Alibaba

Compressed Mean

Easy
CVS Health icon

CVS Health

Pharmacy Analytics (Part 1)

Easy
CVS Health icon

CVS Health

Pharmacy Analytics (Part 2)

Easy
CVS Health icon

CVS Health

Pharmacy Analytics (Part 3)

Easy
UnitedHealth icon

UnitedHealth

Patient Support Analysis (Part 1)

Easy
Uber icon

Uber

User's Third Transaction

Medium
FAANG icon

FAANG

Second Highest Salary

Medium
Snapchat icon

Snapchat

Sending vs. Opening Snaps

Medium
Twitter icon

Twitter

Tweets' Rolling Averages

Medium
Amazon icon

Amazon

Highest-Grossing Items

Medium
FAANG icon

FAANG

Top Three Salaries

Medium
Spotify icon

Spotify

Top 5 Artists

Medium
TikTok icon

TikTok

Signup Activation Rate

Medium
Microsoft icon

Microsoft

Supercloud Customer

Medium
Google icon

Google

Odd and Even Measurements

Medium
Zomato icon

Zomato

Swapped Food Delivery

Medium
Bloomberg icon

Bloomberg

FAANG Stock Min-Max (Part 1)

Medium
Walmart icon

Walmart

Histogram of Users and Purchases

Medium
Alibaba icon

Alibaba

Compressed Mode

Medium
JPMorgan Chase icon

JPMorgan Chase

Card Launch Success

Medium
Verizon icon

Verizon

International Call Percentage

Medium
UnitedHealth icon

UnitedHealth

Patient Support Analysis (Part 2)

Medium
Facebook icon

Facebook

Active User Retention

Hard
Wayfair icon

Wayfair

Y-on-Y Growth Rate

Hard
Amazon icon

Amazon

Maximize Prime Item Inventory

Hard
Google icon

Google

Median Google Search Frequency

Hard
Facebook icon

Facebook

Advertiser Status

Hard
McKinsey icon

McKinsey

3-Topping Pizzas

Hard
FAANG icon

FAANG

Department vs. Company Salary

Hard
Stripe icon

Stripe

Repeated Payments

Hard
Amazon icon

Amazon

Server Utilization Time

Hard

Your Progress

0%

Easy

0/20

Medium

0/17

Hard

0/9

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