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 hard
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 music medium
10%
3.3
91 same day friend request acceptance rate music easy
11%
3.1
94 Top 3 products vs. bottom 3 products ecommerce medium
6%
3.3
99 Page recommendation social medium
12%
3.1
100 Advertiser ROI advertising medium
9%
3.2
104 MAU: Monthly active users mobile easy
19%
3.3
118 Daily bookings in the US hospitality hard
5%
3.2
129 Top 3 and bottom 3 courier ride sharing medium
10%
3.3
140 Daily sales of restaurant 100011 food delivery hard
9%
3.2
150 Countries with above average customers social easy
10%
3.1
162 Number of orders per brand ecommerce easy
40%
3.1
168 Average number of streams in the US video streaming medium
13%
3.2
172 Comments distribution social hard
13%
3.2
179 Members who ever moved from Microsoft to Google human resource medium
35%
3.1
191 Number of replies by group social medium
100%
3.2
194 Daily active users report for new market social easy - 3.2
213 Interchange revenue by issuer and merchant category fintech easy - 3.2