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

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