Chapter 3: Multi-Table Operation


ID Title Level FTPR Lecture
36 Actors from film 'AFRICAN EGG' easy
36%
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
15%
3.1
41 Productive actors vs less-productive actors hard
6%
3.2
42 Films that are in stock vs not in stock medium
11%
3.2
43 Customers who rented vs. those who did not medium
9%
3.2
44 In-demand vs not-in-demand movies medium
6%
3.2
45 Movie inventory optimization hard
7%
3.2
46 Actors and customers whose last name starts with 'A' easy
32%
3.3
47 Actors and customers whose first names end in 'D'. easy
45%
3.3
48 Movie and TV actors easy
43%
3.1
49 Top 3 money making movie categories medium
19%
3.1
50 Top 5 cities for movie rentals easy
23%
3.1
51 Movie only actor easy
43%
3.2
52 Movies cast by movie only actors easy
13%
3.2
53 Movie groups by rental income hard
11%
3.2
54 Customer groups by movie rental spend medium
21%
3.2
55 Busy days and slow days medium
11%
3.2
56 Total number of actors easy
32%
3.2
57 Total number of actors (with UNION) easy
37%
3.3
87 Top song in the US and UK spotify medium
10%
3.3
91 same day friend request acceptance rate spotify easy
11%
3.1
94 Top 3 products vs. bottom 3 products amazon medium
6%
3.3
99 Page recommendation social medium
12%
3.1
100 Advertiser ROI social medium
9%
3.2
104 MAU: Monthly active users mobile easy
19%
3.3
118 Daily bookings in the US airbnb hard
5%
3.2
129 Top 3 and bottom 3 courier uber medium
10%
3.3
140 Daily sales of restaurant 100011 doordash hard
9%
3.2
150 Countries with above average customers social easy
10%
3.1
162 Number of orders per brand walmart easy
40%
3.1
168 Average number of streams in the US tiktok medium
13%
3.2
172 Comments distribution social hard
13%
3.2
179 Members who ever moved from Microsoft to Google linkedin medium
35%
3.1
191 Number of replies by group twitter medium
100%
3.2
194 Daily active users report for new market snap easy - 3.2
213 Interchange revenue by issuer and merchant category visa easy - 3.2

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.