SQL Interview Questions

Practice 180 online SQL coding questions and ace your data job interview.

Nervous about your SQL interview? Try instamentor and hire a FAANG mentor for 1:1 job interview coaching.

ALL QUESTIONS

Affirm SQL Interview Questions Airbnb SQL Interview Questions Afterpay SQL Interview Questions Amazon SQL Interview Questions Doordash SQL Interview Questions Dropbox SQL Interview Questions Ebay SQL Interview Questions Facebook SQL Interview Questions Google SQL Interview Questions Linkedin SQL Interview Questions Lyft SQL Interview Questions Robinhood SQL Interview Questions Spotify SQL Interview Questions Tiktok SQL Interview Questions Uber SQL Interview Questions Walmart SQL Interview Questions

Chapter 3: Multi-Table Operation

ID Title Level FTPR Lecture
36 Actors from film 'AFRICAN EGG' easy
37%
3.1
37 Most popular movie category easy
17%
3.1
38 Most popular movie category (name and id) medium
18%
3.1
39 Most productive actor with inner join easy
23%
3.1
40 Top 2 most rented movie in June 2020 medium
16%
3.1
41 Productive actors vs less-productive actors hard
5%
3.2
42 Films that are in stock vs not in stock medium
13%
3.2
43 Customers who rented vs. those who did not medium
12%
3.2
44 In-demand vs not-in-demand movies medium
5%
3.2
45 Movie inventory optimization hard
9%
3.2
46 Actors and customers whose last name starts with 'A' easy
28%
3.3
47 Actors and customers whose first names end in 'D'. easy
43%
3.3
48 Movie and TV actors easy
44%
3.1
49 Top 3 money making movie categories medium
23%
3.1
50 Top 5 cities for movie rentals easy
18%
3.1
51 Movie only actor easy
48%
3.2
52 Movies cast by movie only actors hard
14%
3.2
53 Movie groups by rental income hard
16%
3.2
54 Customer groups by movie rental spend medium
21%
3.2
55 Busy days and slow days medium
14%
3.2
56 Total number of actors easy
37%
3.2
57 Total number of actors (with UNION) easy
35%
3.3
87 Top song in the US and UK spotify medium
7%
3.3
91 same day friend request acceptance rate facebook easy
14%
3.1
94 Top 3 products vs. bottom 3 products amazon medium
7%
3.3
99 Page recommendation facebook medium
9%
3.1
100 Advertiser ROI facebook medium
0%
3.2
104 MAU: Monthly active users google easy
33%
3.3
118 Daily bookings in the US airbnb hard
7%
3.2
129 Top 3 and bottom 3 courier uber medium
17%
3.3
140 Daily sales of restaurant 100011 doordash hard
50%
3.2
150 Countries with above average customers tiktok easy
50%
3.1
162 Number of orders per brand walmart easy
33%
3.1
168 Average number of streams in the US amazon medium
50%
3.2
172 Comments distribution facebook hard
14%
3.2
179 Members who ever moved from Microsoft to Google linkedin medium
50%
3.1