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
|
easy
|
|
2.2
|
7 |
Unique customers count by month
|
easy
|
|
2.2
|
8 |
Average customer spend by month
|
medium
|
|
2.2
|
9 |
Number of high spend customers by month
|
medium
|
|
2.2
|
10 |
Min and max spend
|
medium
|
|
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
|
difficult
|
|
2.3
|
15 |
Fast movie watchers vs slow watchers
|
difficult
|
|
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
|