1 |
Top store for movie sales
|
easy
|
|
2.1
|
2 |
Top 3 movie categories by sales
|
easy
|
|
2.1
|
3 |
Top 5 shortest movies
|
easy
|
|
2.1
|
4 |
Staff without a profile image
|
easy
|
|
2.1
|
5 |
Monthly revenue
|
easy
|
|
2.2
|
6 |
Daily revenue in June, 2020
|
medium
|
|
2.2
|
7 |
Unique customers count by month
|
easy
|
|
2.2
|
8 |
Average customer spend by month
|
easy
|
|
2.2
|
9 |
Number of high spend customers by month
|
medium
|
|
2.2
|
10 |
Min and max spend
|
easy
|
|
2.2
|
11 |
Actors' last name
|
easy
|
|
2.3
|
12 |
Actors' last name ending in 'EN' or 'RY'
|
easy
|
|
2.3
|
13 |
Actors' first name
|
medium
|
|
2.3
|
14 |
Good days and bad days
|
hard
|
|
2.3
|
15 |
Fast movie watchers vs slow watchers
|
hard
|
|
2.3
|
16 |
Staff who live in Woodridge
|
easy
|
|
2.1
|
17 |
GROUCHO WILLIAMS’ actor_id
|
easy
|
|
2.1
|
18 |
Top film category
|
easy
|
|
2.2
|
19 |
Most productive actor
|
medium
|
|
2.2
|
20 |
Customer who spent the most
|
medium
|
|
2.2
|
21 |
Customer who rented the most
|
medium
|
|
2.2
|
22 |
Average cost per rental transaction
|
easy
|
|
2.3
|
23 |
Average spend per customer in Feb 2020
|
easy
|
|
2.2
|
24 |
Films with more than 10 actors
|
medium
|
|
2.3
|
25 |
Shortest film
|
easy
|
|
2.3
|
26 |
Second shortest film
|
easy
|
|
2.3
|
27 |
Film with the largest cast
|
easy
|
|
2.3
|
28 |
Film with the second largest cast
|
medium
|
|
2.3
|
29 |
Second highest spend customer
|
medium
|
|
2.3
|
30 |
Inactive customers in May
|
easy
|
|
2.3
|
31 |
Movies that have not been returned
|
easy
|
|
2.3
|
32 |
Unpopular movies
|
hard
|
|
2.3
|
33 |
Returning customers
|
medium
|
|
2.3
|
34 |
Stocked up movies
|
easy
|
|
2.3
|
35 |
Film length report
|
easy
|
|
2.3
|
36 |
Actors from film 'AFRICAN EGG'
|
easy
|
|
3.1
|
37 |
Most popular movie category
|
easy
|
|
3.1
|
38 |
Most popular movie category (name and id)
|
medium
|
|
3.1
|
39 |
Most productive actor with inner join
|
easy
|
|
3.1
|
40 |
Top 2 most rented movie in June 2020
|
medium
|
|
3.1
|
41 |
Productive actors vs less-productive actors
|
hard
|
|
3.2
|
42 |
Films that are in stock vs not in stock
|
medium
|
|
3.2
|
43 |
Customers who rented vs. those who did not
|
medium
|
|
3.2
|
44 |
In-demand vs not-in-demand movies
|
medium
|
|
3.2
|
45 |
Movie inventory optimization
|
hard
|
|
3.2
|
46 |
Actors and customers whose last name starts with 'A'
|
easy
|
|
3.3
|
47 |
Actors and customers whose first names end in 'D'.
|
easy
|
|
3.3
|
48 |
Movie and TV actors
|
easy
|
|
3.1
|
49 |
Top 3 money making movie categories
|
medium
|
|
3.1
|
50 |
Top 5 cities for movie rentals
|
easy
|
|
3.1
|
51 |
Movie only actor
|
easy
|
|
3.2
|
52 |
Movies cast by movie only actors
|
easy
|
|
3.2
|
53 |
Movie groups by rental income
|
hard
|
|
3.2
|
54 |
Customer groups by movie rental spend
|
medium
|
|
3.2
|
55 |
Busy days and slow days
|
medium
|
|
3.2
|
56 |
Total number of actors
|
easy
|
|
3.2
|
57 |
Total number of actors (with UNION)
|
easy
|
|
3.3
|
58 |
Percentage of revenue per movie
|
hard
|
|
4.1
|
59 |
Percentage of revenue per movie by category
|
medium
|
|
4.1
|
60 |
Movie rentals and average rentals in the same category
|
hard
|
|
4.1
|
61 |
Customer spend vs average spend in the same store
|
hard
|
|
4.1
|
62 |
Shortest film by category
|
medium
|
|
4.2
|
63 |
Top 5 customers by store
|
hard
|
|
4.2
|
64 |
Top 2 films by category
|
hard
|
|
4.2
|
65 |
Movie revenue percentiles
|
easy
|
|
4.3
|
66 |
Movie percentiles by revenue by category
|
medium
|
|
4.3
|
67 |
Quartile by number of rentals
|
easy
|
|
4.3
|
68 |
Spend difference between first and second rentals
|
hard
|
|
4.4
|
69 |
Number of happy customers
|
hard
|
|
4.4
|
70 |
Cumulative spend
|
easy
|
|
4.1
|
71 |
Cumulative rentals
|
easy
|
|
4.1
|
72 |
Days when they became happy customers
|
medium
|
|
4.2
|
73 |
Number of days to become a happy customer
|
hard
|
|
4.2
|
74 |
The most productive actors by category
|
hard
|
|
4.2
|
75 |
Top customer by movie category
|
medium
|
|
4.2
|
76 |
Districts with the most and least customers
|
easy
|
|
4.2
|
77 |
Movie revenue percentiles by category
|
easy
|
|
4.3
|
78 |
Quartiles buckets by number of rentals
|
medium
|
|
4.3
|
79 |
Spend difference between the last and the second last rentals
|
hard
|
|
4.4
|
80 |
DoD revenue growth for each store
|
hard
|
|
4.4
|
81 |
How many people searched on new year's day
search engine
|
easy
|
|
2.2
|
82 |
The top search query on new year's day
search engine
|
easy
|
|
2.2
|
83 |
Top search_query in US and UK on new year's day
search engine
|
medium
|
|
4.2
|
84 |
Click through rate on new year's day
search engine
|
medium
|
|
2.2
|
85 |
Top 4 queries based on click through rate on new year's day
search engine
|
hard
|
|
2.2
|
86 |
Top song in the US
spotify
|
easy
|
|
2.2
|
87 |
Top song in the US and UK
spotify
|
medium
|
|
3.3
|
88 |
Top song report
spotify
|
medium
|
|
4.2
|
89 |
Top 5 artists in the US
spotify
|
medium
|
|
2.2
|
90 |
Top artist report
spotify
|
medium
|
|
4.2
|
91 |
same day friend request acceptance rate
spotify
|
easy
|
|
3.1
|
92 |
Acceptance rate first week of 2021
spotify
|
easy
|
|
2.1
|
93 |
number of sales for each product this month
amazon
|
easy
|
|
2.2
|
94 |
Top 3 products vs. bottom 3 products
amazon
|
medium
|
|
3.3
|
95 |
Candidate products for subscription
amazon
|
hard
|
|
2.2
|
96 |
Overall acceptance rate
social
|
easy
|
|
2.2
|
97 |
Social influencer
social
|
easy
|
|
2.2
|
98 |
Most popular user
social
|
easy
|
|
2.2
|
99 |
Page recommendation
social
|
medium
|
|
3.1
|
100 |
Advertiser ROI
social
|
medium
|
|
3.2
|
101 |
Average number of visits per user
mobile
|
easy
|
|
2.2
|
102 |
Histogram by visit session duration
mobile
|
hard
|
|
2.3
|
103 |
Median and average session duration by day of the week
mobile
|
medium
|
|
4.3
|
104 |
MAU: Monthly active users
mobile
|
easy
|
|
3.3
|
105 |
Number of days gap between last two actions
mobile
|
hard
|
|
4.2
|
106 |
Mobile vs. web
mobile
|
medium
|
|
2.2
|
107 |
Customer count by platform
mobile
|
medium
|
|
2.2
|
108 |
Free premium membership
amazon
|
hard
|
|
4.1
|
109 |
Top 3 most popular product categories
amazon
|
easy
|
|
4.2
|
110 |
Most popular product by category
amazon
|
medium
|
|
4.2
|
111 |
Second most popular product
amazon
|
medium
|
|
2.1
|
112 |
Top 3 customers
amazon
|
easy
|
|
2.2
|
113 |
Daily cumulative spend
amazon
|
easy
|
|
4.1
|
114 |
Dod revenue change rate
amazon
|
easy
|
|
4.4
|
115 |
Rolling average revenue
amazon
|
hard
|
|
4.1
|
116 |
Top answers day by device
amazon
|
easy
|
|
4.2
|
117 |
Rolling 7 days total answers
amazon
|
easy
|
|
4.1
|
118 |
Daily bookings in the US
airbnb
|
hard
|
|
3.2
|
119 |
Top 2 countries by bookings
airbnb
|
hard
|
|
4.2
|
120 |
First ever booking
airbnb
|
hard
|
|
4.2
|
121 |
Week over week change of first ever bookings
airbnb
|
hard
|
|
4.4
|
122 |
Top country by wow growth
airbnb
|
hard
|
|
4.2
|
123 |
Top listing in the United States, United Kingdom and Canada
airbnb
|
medium
|
|
4.2
|
124 |
Active restaurants by city
uber
|
easy
|
|
2.2
|
125 |
Active restaurants with fewer than 5 trips per city
uber
|
easy
|
|
2.2
|
126 |
Top 3 restaurants
uber
|
hard
|
|
2.1
|
127 |
Average rating after 10th trip
uber
|
hard
|
|
4.2
|
128 |
Completion rate
uber
|
easy
|
|
2.2
|
129 |
Top 3 and bottom 3 courier
uber
|
medium
|
|
3.3
|
130 |
Newly created accounts
affirm
|
easy
|
|
2.2
|
131 |
Churned accounts
affirm
|
hard
|
|
2.3
|
132 |
Top 3 trending countries
affirm
|
medium
|
|
2.2
|
133 |
Small departments
robinhood
|
easy
|
|
2.2
|
134 |
Expensive departments
robinhood
|
medium
|
|
2.2
|
135 |
Unlucky employees
robinhood
|
easy
|
|
4.2
|
136 |
Extremely late orders
doordash
|
easy
|
|
2.3
|
137 |
Extremely late first orders
doordash
|
medium
|
|
4.2
|
138 |
Happy restaurants
doordash
|
easy
|
|
2.3
|
139 |
Poor first delivery experience
doordash
|
medium
|
|
4.2
|
140 |
Daily sales of restaurant 100011
doordash
|
hard
|
|
3.2
|
141 |
Cumulative sales of restaurant 100011
doordash
|
hard
|
|
4.1
|
142 |
First order date
afterpay
|
easy
|
|
4.2
|
143 |
Customer purchase report
afterpay
|
easy
|
|
2.2
|
144 |
Third order
afterpay
|
medium
|
|
4.2
|
145 |
Returning customers after first buy
afterpay
|
hard
|
|
4.2
|
146 |
Purchase by platform
afterpay
|
easy
|
|
2.2
|
147 |
2 days streak customers
social
|
hard
|
|
4.4
|
148 |
Most popular video category
social
|
medium
|
|
4.2
|
149 |
fans by video category
social
|
easy
|
|
2.2
|
150 |
Countries with above average customers
social
|
easy
|
|
3.1
|
151 |
Salary report
dropbox
|
easy
|
|
2.3
|
152 |
Salary analysis
dropbox
|
easy
|
|
2.1
|
153 |
Project ROI
dropbox
|
easy
|
|
2.2
|
154 |
Rideshare completion rate
lyft
|
easy
|
|
2.2
|
155 |
Driver with the highest cancellation rate
lyft
|
easy
|
|
2.3
|
156 |
Cancellation rate by unbanned users
lyft
|
hard
|
|
2.3
|
157 |
Number of trips before a driver got banned
lyft
|
medium
|
|
4.2
|
158 |
First trip completion rate
lyft
|
medium
|
|
4.2
|
159 |
Transaction volume from suspended accounts
ebay
|
easy
|
|
2.2
|
160 |
Sellers with no sales by day
ebay
|
hard
|
|
2.3
|
161 |
Biggest sales day
ebay
|
easy
|
|
2.2
|
162 |
Number of orders per brand
walmart
|
easy
|
|
3.1
|
163 |
Average number of orders per brand
walmart
|
easy
|
|
2.2
|
164 |
Orders distribution by brand
walmart
|
easy
|
|
2.2
|
165 |
Session stitching
walmart
|
hard
|
|
4.2
|
166 |
Top 10 customers based on spend growth
walmart
|
medium
|
|
4.2
|
167 |
Top country in video streaming
tiktok
|
easy
|
|
2.2
|
168 |
Average number of streams in the US
tiktok
|
medium
|
|
3.2
|
169 |
Same day streams
tiktok
|
easy
|
|
2.2
|
170 |
Top 3 countries by average watch time
tiktok
|
easy
|
|
2.2
|
171 |
Binge watches
tiktok
|
easy
|
|
2.2
|
172 |
Comments distribution
social
|
hard
|
|
3.2
|
173 |
User Popularity Percentage
social
|
medium
|
|
2.2
|
174 |
Closed accounts
social
|
easy
|
|
2.2
|
175 |
Employees' email account
amazon
|
easy
|
|
2.1
|
176 |
Employees' annual bonus
amazon
|
easy
|
|
2.3
|
177 |
Purchases by platform report
amazon
|
medium
|
|
2.3
|
178 |
Members who worked at both Microsoft and Google
linkedin
|
medium
|
|
2.3
|
179 |
Members who ever moved from Microsoft to Google
linkedin
|
medium
|
|
3.1
|
180 |
Members moved from Microsoft to Google directly.
linkedin
|
hard
|
|
4.4
|
181 |
Users who watched less than one hour of Netflix
netflix
|
easy
|
|
2.2
|
182 |
Top 5 content by number of watchers
netflix
|
medium
|
|
4.1
|
183 |
Top 5 movies by number of watchers
netflix
|
easy
|
|
2.2
|
184 |
Top 5 movies by watch time
netflix
|
medium
|
|
2.2
|
185 |
Top 5 non-English contents by watch time
netflix
|
medium
|
|
2.2
|
186 |
Average comments per question
google
|
easy
|
|
2.2
|
187 |
Comment distribution at Google Forum
google
|
easy
|
|
2.2
|
188 |
Top 1 popular question by department
google
|
hard
|
|
4.2
|
189 |
Campaign activation date
twitter
|
medium
|
|
4.1
|
190 |
Twitter campaign spend report
twitter
|
hard
|
|
2.2
|
191 |
Number of replies by group
twitter
|
medium
|
|
3.2
|
192 |
Number of replies to the original tweet by group
twitter
|
medium
|
|
2.2
|
193 |
Difference of replies by testing groups
twitter
|
medium
|
|
2.2
|
194 |
Daily active users report for new market
snap
|
easy
|
|
3.2
|
195 |
MoM user growth
snap
|
hard
|
|
4.4
|
196 |
User segments report
snap
|
hard
|
|
2.2
|
197 |
Students who didn't finish all subjects
snap
|
easy
|
|
2.2
|
198 |
Average score per subject
snap
|
easy
|
|
2.2
|
199 |
Students improvement
snap
|
hard
|
|
4.4
|
200 |
Last week's absent students
snap
|
medium
|
|
2.1
|
201 |
Top 3 students for each subject
snap
|
hard
|
|
4.2
|
202 |
Monthly active paid subscriptions
apple
|
hard
|
|
2.2
|
203 |
Top product by country by month
apple
|
easy
|
|
4.2
|
204 |
AB testing sanity check
apple
|
easy
|
|
2.2
|
205 |
Search results recall
apple
|
medium
|
|
2.2
|
206 |
Search results recall by testing group
apple
|
medium
|
|
2.2
|
207 |
Results shown rate by group
apple
|
medium
|
|
2.2.1
|
208 |
Top 3 urls by testing groups
apple
|
hard
|
|
4.2
|
209 |
Card issuer customers count
visa
|
easy
|
-
|
2.2
|
210 |
Issuer and merchant report
visa
|
easy
|
-
|
2.1
|
211 |
High spenders by issuer
visa
|
easy
|
-
|
2.1
|
212 |
Top issuing bank by category
visa
|
hard
|
-
|
2.1
|
213 |
Interchange revenue by issuer and merchant category
visa
|
easy
|
-
|
3.2
|
214 |
D30 retention rate
roblox
|
hard
|
-
|
2.2
|
215 |
Monthly active users
roblox
|
hard
|
-
|
2.2
|
216 |
Highest spender
roblox
|
hard
|
-
|
2.2
|