logo

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).

CompanyTitleDifficultyStatus

Twitter

Histogram of Tweets

Easy

LinkedIn

Data Science Skills

Easy

Facebook

Page With No Likes

Easy

Tesla

Unfinished Parts

Easy

New York Times

Laptop vs. Mobile Viewership

Easy

Facebook

Average Post Hiatus (Part 1)

Easy

Microsoft

Teams Power Users

Easy

Linkedin

Duplicate Job Listings

Easy

Robinhood

Cities With Completed Trades

Easy

Amazon

Average Review Ratings

Easy

Facebook

App Click-through Rate (CTR)

Easy

TikTok

Second Day Confirmation

Easy

IBM

IBM db2 Product Analytics

Easy

JPMorgan Chase

Cards Issued Difference

Easy

Alibaba

Compressed Mean

Easy

CVS Health

Pharmacy Analytics (Part 1)

Easy

CVS Health

Pharmacy Analytics (Part 2)

Easy

CVS Health

Pharmacy Analytics (Part 3)

Easy

UnitedHealth

Patient Support Analysis (Part 1)

Easy

Uber

User's Third Transaction

Medium

FAANG

Second Highest Salary

Medium

Snapchat

Sending vs. Opening Snaps

Medium

Twitter

Tweets' Rolling Averages

Medium

Amazon

Highest-Grossing Items

Medium

FAANG

Top Three Salaries

Medium

Spotify

Top 5 Artists

Medium

TikTok

Signup Activation Rate

Medium

Microsoft

Supercloud Customer

Medium

Google

Odd and Even Measurements

Medium

Walmart

Histogram of Users and Purchases

Medium

Alibaba

Compressed Mode

Medium

JPMorgan Chase

Card Launch Success

Medium

Verizon

International Call Percentage

Medium

UnitedHealth

Patient Support Analysis (Part 2)

Medium

Facebook

Active User Retention

Hard

Wayfair

Y-on-Y Growth Rate

Hard

Amazon

Maximize Prime Item Inventory

Hard

Google

Median Google Search Frequency

Hard

Facebook

Advertiser Status

Hard

McKinsey

3-Topping Pizzas

Hard

Stripe

Repeated Payments

Hard

Oracle

Who Made Quota?

Easy

Amazon

Server Utilization Time

Hard

Zomato

Swapped Food Delivery

Medium

FAANG

Department vs. Company Salary

Hard

FAANG

Well Paid Employees

Easy

Bloomberg

FAANG Stock Min-Max (Part 1)

Medium

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