Window Functions: Lecture 2: ROW_NUMBER, RANK, DENSE_RANK


ID Title Level FTPR Lecture
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
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
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
105 Number of days gap between last two actions mobile hard
9%
4.2
109 Top 3 most popular product categories ecommerce easy
11%
4.2
110 Most popular product by category ecommerce medium
11%
4.2
116 Top answers day by device ai easy
14%
4.2
119 Top 2 countries by bookings hospitality hard
6%
4.2
120 First ever booking hospitality hard
7%
4.2
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
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
148 Most popular video category social medium
12%
4.2
157 Number of trips before a driver got banned ride sharing medium
5%
4.2
158 First trip completion rate ride sharing medium
21%
4.2
165 Session stitching mobile hard
15%
4.2
166 Top 10 customers based on spend growth ecommerce medium
13%
4.2
188 Top 1 popular question by department forum hard
100%
4.2
201 Top 3 students for each subject education medium - 4.2
203 Top 5 products by country by month search engine easy - 4.2
208 Top 3 urls by testing groups search engine medium - 4.2