SQL & Data Interview Questions

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

CompanyTitleCategoryDifficultyStatus
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
Apple icon

Apple

Word Search

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

Tags

Distinct and Unique Handling

23

Aggregate Functions

84

Set Operations

16

Data Type Conversion

29

Null Handling

7

Percentage Calculations

20

Array Functions

3

Ace the Data Science Interview

28

String Functions

5

Date-Time Functions

30

Control Flow Functions

1

User Behavior

14

Common Table Expressions (CTE) or Subquery

40

Window Functions

38

Data Generation Functions

1

Joins

12

Existence Check

9

Mathematical Functions

20

Conditional Expression

39

Arithmetic Operators

4

Top N Results

12

Conditional Logic

30

© 2025 DataLemur, Inc

Career Resources

Free 9-Day Data Interview Crash CourseFree SQL Tutorial for Data AnalyticsSQL Interview Cheat Sheet PDFUltimate SQL Interview GuideAce the Data Job Hunt Video CourseAce the Data Science InterviewBest Books for Data AnalystsSQL Squid Game