Dashboard Problems Companies Topics SQL System Design AI

No account needed. Your solved list, notes and streak are saved in this browser. Export them from Settings.

Companies

Dashboard Problems Companies System Design

Search

Jump to any problem, company or topic

SQL Top 50 practice set · FAANGrind

SQL Top 50

Set Curated practice set

The 50 most-asked SQL interview problems, ordered from easy to hard.

Problems: 50
List: Curated
Topics: 6

50 problems

TopicsLinks

1

1.Email Duplicates

Easy1 co.

Easy

Aggregation & Grouping

also at 0 more

2

2.Big Countries

Easy1 co.

Easy

Filtering & Sorting

also at 0 more

3

3.Highest Order Placing Customer

Easy1 co.

Easy

Aggregation & Grouping

also at 0 more

4

4.Employees Earning More Than Their Manager

Easy1 co.

Easy

Joins & Relationships

also at 0 more

5

5.Odd Non-Boring Movies

Easy1 co.

Easy

Filtering & Sorting

also at 0 more

6

6.Non-Referred Customers

Easy1 co.

Easy

Conditional Logic & NULL Handling

also at 0 more

7

7.Low Bonus Employees

Easy1 co.

Easy

Joins & Relationships

also at 0 more

8

8.Visitors Without Transactions

Easy1 co.

Easy

Joins & Relationships

also at 0 more

9

9.Unique Subjects per Teacher

Easy1 co.

Easy

Aggregation & Grouping

also at 0 more

10

10.First Login Analysis

Easy1 co.

Easy

Aggregation & Grouping

also at 0 more

11

11.Large Classes

Easy1 co.

Easy

Aggregation & Grouping

also at 0 more

12

12.Average Experience by Project

Easy1 co.

Easy

Aggregation & Grouping

also at 0 more

13

13.Salespersons Without RED Orders

Easy1 co.

Easy

Subqueries & Set Logic

also at 0 more

14

14.Product Selling Price Report

Easy1 co.

Easy

Aggregation & Grouping

also at 0 more

15

15.Instant Food Delivery

Easy1 co.

Easy

Aggregation & Grouping

also at 0 more

16

16.Most Frequent Travellers

Easy1 co.

Easy

Joins & Relationships

also at 0 more

17

17.Inactive Sellers

Easy1 co.

Easy

Subqueries & Set Logic

also at 0 more

18

18.Inactive Customers

Easy1 co.

Easy

Subqueries & Set Logic

also at 0 more

19

19.Contest Participation Rate

Easy1 co.

Easy

Aggregation & Grouping

also at 0 more

20

20.Highest Non-Repeating Number

Easy1 co.

Easy

Aggregation & Grouping

also at 0 more

21

21.Sales Analysis

Easy1 co.

Easy

Joins & Relationships

also at 0 more

22

22.Valid Triangle Check

Easy1 co.

Easy

Conditional Logic & NULL Handling

also at 0 more

23

23.User Follower Count

Easy1 co.

Easy

Aggregation & Grouping

also at 0 more

24

24.Exceeding Tweet Length

Easy1 co.

Easy

String Functions

also at 0 more

25

25.Special Bonus Calculation

Easy1 co.

Easy

Conditional Logic & NULL Handling

also at 0 more

26

26.Latest 2020 Login

Easy1 co.

Easy

Date & Time Functions

also at 0 more

27

27.Students Enrolled in Non-Existent Departments

Easy1 co.

Easy

Subqueries & Set Logic

also at 0 more

28

28.Employee Work Time Summary

Easy1 co.

Easy

Aggregation & Grouping

also at 0 more

29

29.Incomplete Employee Records

Easy1 co.

Easy

Set Operations & Merging

also at 0 more

30

30.Frequent Actor-Director Duos

Easy1 co.

Easy

Aggregation & Grouping

also at 0 more

31

31.Find Team Size for Each Employee

Easy1 co.

Easy

Window Functions

also at 0 more

32

32.Minimum Distance Between Points

Easy1 co.

Easy

Joins & Relationships

also at 0 more

33

33.Top Grade per Student

Medium1 co.

Medium

Window Functions

also at 0 more

34

Medium1 co.

Medium

Joins & Relationships

also at 0 more

35

35.All-Product Buyers

Medium1 co.

Medium

Subqueries & Set Logic

also at 0 more

36

36.Immediate First Orders Percentage

Medium1 co.

Medium

Aggregation & Grouping

also at 0 more

37

37.Employees with the Highest Salary in Each Department

Medium1 co.

Medium

Aggregation & Grouping

also at 0 more

38

38.Node Classification

Medium1 co.

Medium

Conditional Logic & NULL Handling

also at 0 more

39

39.High-Report Managers

Medium1 co.

Medium

Aggregation & Grouping

also at 0 more

40

40.Football Team Scores

Medium1 co.

Medium

Aggregation & Grouping

also at 0 more

41

41.Find Continuous Ranges in Logs

Medium1 co.

Medium

Window Functions

also at 0 more

42

42.Top Ratings in Feb 2020

Medium1 co.

Medium

also at 0 more

43

43.A & B Buyers Without C

Medium1 co.

Medium

Aggregation & Grouping

also at 0 more

44

44.Apples vs Oranges

Medium1 co.

Medium

Aggregation & Grouping

also at 0 more

45

45.Follow-up Game Activity

Medium1 co.

Medium

Window Functions

also at 0 more

46

46.Swap Consecutive Seats

Medium1 co.

Medium

Conditional Logic & NULL Handling

also at 0 more

47

47.Find the Largest Window Between User Visits

Medium1 co.

Medium

Window Functions

also at 0 more

48

48.Find All Employees Reporting to the Head of the Company

Medium1 co.

Medium

CTEs & Recursion

also at 0 more

49

49.Top 3 Salaries per Department

Hard1 co.

Hard

Window Functions

also at 0 more

50

50.Track Continuous Periods of Task Failures and Successes

Hard1 co.

Hard

Window Functions

also at 0 more

Showing 1–50 of 50

Difficulty split

Easy32(64%)
Medium16(32%)
Hard2(4%)

Top topics

Aggregation & Grouping19
Joins & Relationships7
Window Functions7
Conditional Logic & NULL Handling5
Subqueries & Set Logic5
Filtering & Sorting2