Chapter 4: Window Functions


ID Title Level FTPR Lecture
58 Percentage of revenue per movie hard
8%
4.1
59 Percentage of revenue per movie by category medium
7%
4.1
60 Movie rentals and average rentals in the same category hard
9%
4.1
61 Customer spend vs average spend in the same store hard
12%
4.1
62 Shortest film by category medium
9%
4.2
63 Top 5 customers by store hard
8%
4.2
64 Top 2 films by category hard
16%
4.2
65 Movie revenue percentiles easy
16%
4.3
66 Movie percentiles by revenue by category medium
19%
4.3
67 Quartile by number of rentals easy
24%
4.3
68 Spend difference between first and second rentals hard
12%
4.4
69 Number of happy customers hard
12%
4.4
70 Cumulative spend easy
14%
4.1
71 Cumulative rentals easy
18%
4.1
72 Days when they became happy customers medium
10%
4.2
73 Number of days to become a happy customer hard
11%
4.2
74 The most productive actors by category hard
11%
4.2
75 Top customer by movie category medium
28%
4.2
76 Districts with the most and least customers easy
11%
4.2
77 Movie revenue percentiles by category easy
20%
4.3
78 Quartiles buckets by number of rentals medium
23%
4.3
79 Spend difference between the last and the second last rentals hard
18%
4.4
80 DoD revenue growth for each store hard
19%
4.4
83 Top search_query in US and UK on new year's day search engine medium
6%
4.2
88 Top song report music medium
23%
4.2
90 Top artist report music medium
22%
4.2
103 Median and average session duration by day of the week mobile medium
17%
4.3
105 Number of days gap between last two actions mobile hard
9%
4.2
108 Free premium membership ecommerce hard
17%
4.1
109 Top 3 most popular product categories ecommerce easy
11%
4.2
110 Most popular product by category ecommerce medium
11%
4.2
113 Daily cumulative spend ecommerce easy
9%
4.1
114 Dod revenue change rate ecommerce easy
13%
4.4
115 Rolling average revenue ecommerce hard
26%
4.1
116 Top answers day by device ai easy
14%
4.2
117 Rolling 7 days total answers ai easy
35%
4.1
119 Top 2 countries by bookings hospitality hard
6%
4.2
120 First ever booking hospitality hard
7%
4.2
121 Week over week change of first ever bookings hospitality hard
6%
4.4
122 Top country by wow growth hospitality hard
8%
4.2
123 Top listing in the United States, United Kingdom and Canada hospitality medium
8%
4.2
127 Average rating after 10th trip ride sharing hard
11%
4.2
135 Unlucky employees human resource easy
15%
4.2
137 Extremely late first orders food delivery medium
7%
4.2
139 Poor first delivery experience food delivery medium
14%
4.2
141 Cumulative sales of restaurant 100011 food delivery hard
16%
4.1
142 First order date fintech easy
34%
4.2
144 Third order fintech medium
10%
4.2
145 Returning customers after first buy fintech hard
15%
4.2
147 2 days streak customers social hard
11%
4.4