Single Table Operation: Lecture 2: COUNT, SUM, AVERAGE, MIN, MAX, GROUP BY, HAVING


ID Title Level FTPR Lecture
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
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
23 Average spend per customer in Feb 2020 easy
16%
2.2
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
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
106 Mobile vs. web mobile medium
9%
2.2
107 Customer count by platform mobile medium
19%
2.2
112 Top 3 customers ecommerce easy
30%
2.2
124 Active restaurants by city food delivery easy
36%
2.2
125 Active restaurants with fewer than 5 trips per city food delivery easy
14%
2.2
128 Completion rate ride sharing easy
23%
2.2
130 Newly created accounts fintech easy
34%
2.2
132 Top 3 trending countries fintech medium
8%
2.2
133 Small departments human resource easy
44%
2.2
134 Expensive departments human resource medium
32%
2.2
143 Customer purchase report fintech easy
15%
2.2
146 Purchase by platform fintech easy
13%
2.2
149 fans by video category social easy
30%
2.2
153 Project ROI human resource easy
18%
2.2
154 Rideshare completion rate ride sharing easy
22%
2.2
159 Transaction volume from suspended accounts ecommerce easy
51%
2.2
161 Biggest sales day ecommerce easy
19%
2.2
163 Average number of orders per brand ecommerce easy
36%
2.2
164 Orders distribution by brand ecommerce easy
22%
2.2
167 Top country in video streaming video streaming easy
24%
2.2
169 Same day streams video streaming easy
29%
2.2
170 Top 3 countries by average watch time video streaming easy
10%
2.2
171 Binge watches video streaming easy
19%
2.2
173 User Popularity Percentage social medium
5%
2.2
174 Closed accounts social easy
18%
2.2
181 Users who watched less than one hour of Netflix video streaming easy
23%
2.2
183 Top 5 movies by number of watchers video streaming easy
33%
2.2