SQL & Data Interview Questions

Practice the most common SQL, Statistics, ML, and Python questions asked in FAANG Data Science & Data Analyst interviews!

CompanyTitleCategoryDifficulty
Facebook icon

Facebook

Active User Retention

SQLHard
Wayfair icon

Wayfair

Y-on-Y Growth Rate

SQLHard
Amazon icon

Amazon

Maximize Prime Item Inventory

SQLHard
Google icon

Google

Median Google Search Frequency

SQLHard
Facebook icon

Facebook

Advertiser Status

SQLHard
McKinsey icon

McKinsey

3-Topping Pizzas

SQLHard
Facebook icon

Facebook

Product vs. Square

StatisticsHard
Robinhood icon

Robinhood

Modeling User Churn

Machine LearningHard
FAANG icon

FAANG

Department vs. Company Salary

SQLHard
Stripe icon

Stripe

Repeated Payments

SQLHard
Google icon

Google

Minimum of Two Uniform Variables

StatisticsHard
Microsoft icon

Microsoft

Frequentist vs. Bayesian

StatisticsHard
Amazon icon

Amazon

Server Utilization Time

SQLHard

Your Progress

0%

Easy

0/35

Medium

0/30

Hard

0/13

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