multi-table SQL Interview Questions

Master the world of data! Dive into SQL & Python interview questions and get ready for your SQL interview!

ALL QUESTIONS

affirm afterpay airbnb amazon apple doordash dropbox ebay facebook google linkedin lyft microsoft netflix robinhood roblox snap spotify tiktok twitter uber visa walmart

Chapter 3: Multi-Table


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 questions and their associated data from the internet, but we are not associated with any of the companies or organizations that may be mentioned in these questions. While we strive to provide accurate and up-to-date information, we cannot guarantee the accuracy or completeness of the information provided. Users should exercise their own discretion when using the platform and should not rely solely on the information provided. By using SQLPad, you acknowledge and agree that we are not responsible for any errors or inaccuracies in the information, and that you assume all risks associated with using the platform. You also agree to our terms and conditions.