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

LinkedIn

Data Science Skills

Easy

Facebook

Page With No Likes

Easy

Tesla

Unfinished Parts

Easy

New York Times

Laptop vs. Mobile Viewership

Easy

Linkedin

Duplicate Job Listings

Easy

Facebook

Average Post Hiatus (Part 1)

Easy

Microsoft

Teams Power Users

Easy

Robinhood

Cities With Completed Trades

Easy

Amazon

Average Review Ratings

Easy

Facebook

App Click-through Rate (CTR)

Easy

TikTok

Second Day Confirmation

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

UnitedHealth

Patient Support Analysis (Part 2)

Easy

Uber

User's Third Transaction

Medium

Snapchat

Sending vs. Opening Snaps

Medium

Twitter

Tweets' Rolling Averages

Medium

Amazon

Highest-Grossing Items

Medium

Spotify

Top 5 Artists

Medium

TikTok

Signup Activation Rate

Medium

Accenture

Fill Missing Client Data

Medium

Walmart

Frequently Purchased Pairs

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

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

UnitedHealth

Patient Support Analysis (Part 3)

Hard

UnitedHealth

Patient Support Analysis (Part 4)

Hard

Stripe

Repeated Payments

Hard

Your Progress

0%

Refer Friends To Unlock More Questions

Tags

Calculate Rates7

Array Functions2

Minimum/Maximum4

Date-Time Operations13

Mathematical Functions3

Aggregations24

Ace the Data Science Interview15

Type Conversion12

Categorize Data15

Window Functions12

Top X5

Existence Check5

Cumulative Sums0

SQL Series1

Conditional Aggregation8

String Functions2

Unique Results8

User Behavior5