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
|
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
|
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
|
89 |
Top 5 artists in the US
spotify
|
medium
|
|
2.2
|
92 |
Acceptance rate first week of 2021
spotify
|
easy
|
|
2.1
|
93 |
number of sales for each product this month
amazon
|
easy
|
|
2.2
|
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
|
101 |
Average number of visits per user
mobile
|
easy
|
|
2.2
|
102 |
Histogram by visit session duration
mobile
|
hard
|
|
2.3
|
106 |
Mobile vs. web
mobile
|
medium
|
|
2.2
|
107 |
Customer count by platform
mobile
|
medium
|
|
2.2
|
111 |
Second most popular product
amazon
|
medium
|
|
2.1
|
112 |
Top 3 customers
amazon
|
easy
|
|
2.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
|
128 |
Completion rate
uber
|
easy
|
|
2.2
|
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
|
136 |
Extremely late orders
doordash
|
easy
|
|
2.3
|
138 |
Happy restaurants
doordash
|
easy
|
|
2.3
|
143 |
Customer purchase report
afterpay
|
easy
|
|
2.2
|
146 |
Purchase by platform
afterpay
|
easy
|
|
2.2
|
149 |
fans by video category
social
|
easy
|
|
2.2
|
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
|
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
|
163 |
Average number of orders per brand
walmart
|
easy
|
|
2.2
|
164 |
Orders distribution by brand
walmart
|
easy
|
|
2.2
|
167 |
Top country in video streaming
tiktok
|
easy
|
|
2.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
|
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
|
181 |
Users who watched less than one hour of Netflix
netflix
|
easy
|
|
2.2
|
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
|
190 |
Twitter campaign spend report
twitter
|
hard
|
|
2.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
|
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
|
200 |
Last week's absent students
snap
|
medium
|
|
2.1
|
202 |
Monthly active paid subscriptions
apple
|
hard
|
|
2.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
|
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
|
214 |
D30 retention rate
roblox
|
hard
|
-
|
2.2
|
215 |
Monthly active users
roblox
|
hard
|
-
|
2.2
|
216 |
Highest spender
roblox
|
hard
|
-
|
2.2
|