Practice Questions

multi-table SQL Interview Questions

Master SQL interview patterns with structured question sets, company filters, and run-ready challenges.

Questions Showing

39

Companies

23

Access Tier

Free

ID Title Level FTPR Lecture
36 Actors from film 'AFRICAN EGG' Easy

32%

3.1
37 Most popular movie category Easy

15%

3.1
38 Most popular movie category (name and id) Medium

19%

3.1
39 Most productive actor with inner join Easy

22%

3.1
40 Top 2 most rented movie in June 2020 Medium

14%

3.1
41 Productive actors vs less-productive actors Hard

7%

3.2
42 Films that are in stock vs not in stock Medium

12%

3.2
43 Customers who rented vs. those who did not Medium

8%

3.2
44 In-demand vs not-in-demand movies Medium

6%

3.2
45 Movie inventory optimization Hard

9%

3.2
46 Actors and customers whose last name starts with 'A' Easy

31%

3.3
47 Actors and customers whose first names end in 'D'. Easy

40%

3.3
48 Movie and TV actors Easy

38%

3.1
49 Top 3 money making movie categories Medium

18%

3.1
50 Top 5 cities for movie rentals Easy

22%

3.1
51 Movie only actor Easy

37%

3.2
52 Movies cast by movie only actors Easy

11%

3.2
53 Movie groups by rental income Hard

11%

3.2
54 Customer groups by movie rental spend Medium

20%

3.2
55 Busy days and slow days Medium

10%

3.2
56 Total number of actors Easy

30%

3.2
57 Total number of actors (with UNION) Easy

37%

3.3
87 Top song in the US and UK spotify Medium

9%

3.3
91 same day friend request acceptance rate spotify Easy

13%

3.1
94 Top 3 products vs. bottom 3 products amazon Medium

7%

3.3
99 Page recommendation facebook Medium

13%

3.1
100 Advertiser ROI facebook Medium

8%

3.2
104 MAU: Monthly active users google Easy

20%

3.3
118 Daily bookings in the US airbnb Hard

5%

3.2
129 Top 3 and bottom 3 courier uber Medium

9%

3.3
140 Daily sales of restaurant 100011 doordash Hard

8%

3.2
150 Countries with above average customers google Easy

15%

3.1
162 Number of orders per brand walmart Easy

41%

3.1
168 Average number of streams in the US tiktok Medium

13%

3.2
172 Comments distribution facebook Hard

13%

3.2
179 Members who ever moved from Microsoft to Google linkedin Medium

31%

3.1
191 Number of replies by group twitter Medium

18%

3.2
194 Daily active users report for new market snap Easy

20%

3.2
213 Interchange revenue by issuer and merchant category visa Easy

70%

3.1

Disclaimer: SQLPad collects interview questions and sample data from public sources. We are not affiliated with the companies mentioned in these exercises. Please review our terms and conditions.