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