SQL & Data Interview Questions

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

CompanyTitleCategoryDifficulty
Microsoft icon

Microsoft

Factorial Formula

PythonEasy
Google icon

Google

Fizz Buzz Sum

PythonEasy
Palantir icon

Palantir

Roman to Integer

PythonEasy
Amazon icon

Amazon

Intersection of Two Lists

PythonEasy
Bloomberg icon

Bloomberg

Collatz Sequence Steps

PythonEasy
Apple icon

Apple

Contains Duplicate

PythonEasy
Facebook icon

Facebook

Straight Line

PythonEasy
Capital One icon

Capital One

Base 13 Conversion

PythonEasy
Uber icon

Uber

Pascals Triangle

PythonEasy
Spotify icon

Spotify

Is Palindrome

PythonEasy
Oracle icon

Oracle

Arithmetic Triplets

PythonEasy
Stripe icon

Stripe

Maximum Sum of a Matrix

PythonMedium
Palantir icon

Palantir

Integer to Roman

PythonMedium
D.E. Shaw icon

D.E. Shaw

Maximum Product of Three Numbers

PythonMedium
Amazon icon

Amazon

Two Sum

PythonMedium
Facebook icon

Facebook

Largest Prime Factor

PythonMedium
Google icon

Google

Smallest Multiple

PythonMedium
AQR icon

AQR

Pearson Correlation Coefficient

PythonMedium
Akuna Capital icon

Akuna Capital

Largest Contiguous Subarray Sum

PythonMedium

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