Chapter 2: Single Table Operation


ID Title Level FTPR Lecture
1 Top store for movie sales easy
30%
2.1
2 Top 3 movie categories by sales easy
47%
2.1
3 Top 5 shortest movies easy
53%
2.1
4 Staff without a profile image easy
67%
2.1
5 Monthly revenue easy
24%
2.2
6 Daily revenue in June, 2020 medium
11%
2.2
7 Unique customers count by month easy
19%
2.2
8 Average customer spend by month easy
22%
2.2
9 Number of high spend customers by month medium
4%
2.2
10 Min and max spend easy
13%
2.2
11 Actors' last name easy
24%
2.3
12 Actors' last name ending in 'EN' or 'RY' easy
30%
2.3
13 Actors' first name medium
13%
2.3
14 Good days and bad days hard
4%
2.3
15 Fast movie watchers vs slow watchers hard
5%
2.3
16 Staff who live in Woodridge easy
72%
2.1
17 GROUCHO WILLIAMS’ actor_id easy
65%
2.1
18 Top film category easy
25%
2.2
19 Most productive actor medium
14%
2.2
20 Customer who spent the most medium
15%
2.2
21 Customer who rented the most medium
20%
2.2
22 Average cost per rental transaction easy
43%
2.3
23 Average spend per customer in Feb 2020 easy
16%
2.2
24 Films with more than 10 actors medium
20%
2.3
25 Shortest film easy
46%
2.3
26 Second shortest film easy
29%
2.3
27 Film with the largest cast easy
27%
2.3
28 Film with the second largest cast medium
25%
2.3
29 Second highest spend customer medium
16%
2.3
30 Inactive customers in May easy
21%
2.3
31 Movies that have not been returned easy
27%
2.3
32 Unpopular movies hard
16%
2.3
33 Returning customers hard
8%
2.3
34 Stocked up movies easy
28%
2.3
35 Film length report easy
26%
2.3
81 How many people searched on new year's day search engine easy
24%
2.2
82 The top search query on new year's day search engine easy
12%
2.2
84 Click through rate on new year's day search engine medium
10%
2.2
85 Top 5 queries based on click through rate on new year's day search engine hard
6%
2.2
86 Top song in the US music easy
19%
2.2
89 Top 5 artists in the US music medium
11%
2.2
92 Acceptance rate first week of 2021 music easy
14%
2.1
93 number of sales for each product this month ecommerce easy
19%
2.2
95 Candidate products for subscription ecommerce hard
11%
2.2
96 Overall acceptance rate social easy
13%
2.2
97 Social influencer social easy
10%
2.2
98 Most popular user social easy
29%
2.2
101 Average number of visits per user mobile easy
12%
2.2
102 Histogram by visit session duration mobile hard
12%
2.3
106 Mobile vs. web mobile medium
9%
2.2