SQL & Data Interview Questions

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

CompanyTitleCategoryDifficultyStatus

Lazy Movie Raters

ProbabilityMedium

User's Third Transaction

SQLMedium

Second Highest Salary

SQLMedium

Sending vs. Opening Snaps

SQLMedium

Tweets' Rolling Averages

SQLMedium

Consecutive Fives

StatisticsMedium

Highest-Grossing Items

SQLMedium

Top Three Salaries

SQLMedium

Top 5 Artists

SQLMedium

Signup Activation Rate

SQLMedium

Looping Number

PythonMedium

Gift Card Satisfaction

PythonMedium

Matrix Rotation

PythonMedium

Clock-wise Matrix Rotation

PythonMedium

Min Amplitude

PythonMedium

Average Subarray

PythonMedium

k-Radius Average

PythonMedium

Idle GPU Days

PythonMedium

Hill Climbing

PythonMedium

Video Ads Insertion

PythonMedium

Spiral Matrix

PythonMedium

Integer to Roman

PythonMedium

Data Conference Attendees

PythonMedium

Supercloud Customer

SQLMedium

Real Estate Modelling

Machine LearningMedium

Generate Fractions

PythonMedium

Max Product of Three Numbers

PythonMedium

Two Sum

PythonMedium

Rotating Factorial

PythonMedium

Pearson Correlation Coefficient

PythonMedium

Largest Contiguous Subarray Sum

PythonMedium

Biased Coin?

StatisticsMedium

Odd and Even Measurements

SQLMedium

Swapped Food Delivery

SQLMedium

Coin Change

PythonMedium

FAANG Stock Min-Max (Part 1)

SQLMedium

User Shopping Sprees

SQLMedium

Histogram of Users and Purchases

SQLMedium

Compressed Mode

SQLMedium

Card Launch Success

SQLMedium

International Call Percentage

SQLMedium

Patient Support Analysis (Part 2)

SQLMedium

Connection Request Spam

Machine LearningMedium

Your Progress

0%

Tags

Percentage Calculations

2

Python test tag

1

Joins

2

Array Functions

2

Date-Time Functions

1

Mathematical Functions

2

Aggregate Functions

2

Ace the Data Science Interview

2

Data Type Conversion

2

Data Generation Functions

2

Window Functions

2

Set Operations

2

Null Handling

2

Conditional Expression

2

Top N Results

2

Control Flow Functions

2

Arithmetic Operators

2

Existence Check

2

Conditional Logic

2

Common Table Expressions (CTE) or Subquery

2

TEST TAG

1

String Functions

2

Distinct and Unique Handling

2

User Behavior

2

© 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