Netflix
Nr | Company | Difficulty | ID Number | Title | Link | Table |
---|---|---|---|---|---|---|
1 | Netflix | Easy | ID 9687 | Find details of oscar winners between 2001 and 2009 | oscar_nominees | |
2 | Netflix | Easy | ID 10128 | Count the number of movies that Abigail Breslin nominated for oscar | oscar_nominees | |
3 | Netflix | Medium | ID 9605 | Find the average rating of movie stars | nominee_filmography | |
4 | Netflix | Medium | ID 9750 | Find the nominee who has won the most Oscars | oscar_nominees | |
5 | Netflix | Medium | ID 9751 | Nominees Without An Oscar | oscar_nominees | |
6 | Netflix | Medium | ID 9752 | Win-to-Nomination Ratio | oscar_nominees | |
7 | Netflix | Medium | ID 9753 | Find movies that had the most nominated actors/actresses | oscar_nominees | |
8 | Netflix | Medium | ID 9754 | Best Actors/Actresses Of All Time | oscar_nominees | |
9 | Netflix | Medium | ID 2102 | Flags per Video | user_flags | |
10 | Netflix | Medium | ID 2133 | First Three Most Watched Videos | videos_watched | |
11 | Netflix | Hard | ID 2054 | Consecutive Days | sf_events | |
12 | Netflix | Hard | ID 10171 | Find the genre of the person with the most number of oscar winnings | oscar_nominees, nominee_information | |
13 | Netflix | Hard | ID 9606 | Differences In Movie Ratings | nominee_filmography, nominee_information |
EASY
Find details of oscar winners between 2001 and 2009
Find the details of oscar winners between 2001 and 2009.
MEDIUM
Flags per Video
For each video, find how many unique users flagged it. A unique user can be identified using the combination of their first name and last name. Do not consider rows in which there is no flag ID. Table(s): user_flags
Best Actors/Actresses Of All Time
Find the best actors/actresses of all time based on the number of Oscar awards. Output nominees alongside their number of Oscars. Order records in descending order based on the number of awards.
First Three Most Watched Videos
After a new user creates an account and starts watching videos, the user ID, video ID, and date watched are captured in the database. Find the top 3 videos most users have watched as their first 3 videos. Output the video ID and the number of times it has been watched as the users' first 3 videos.
In the event of a tie, output all the videos in the top 3 that users watched as their first 3 videos.
Table(s): videos_watched
HARD
Consecutive Days
Find all the users who were active for 3 consecutive days or more.
Find the genre of the person with the most number of oscar winnings
Find the genre of the person with the most number of oscar winnings. If there are more than one person with the same number of oscar wins, return the first one in alphabetic order based on their name. Use the names as keys when joining the tables.
Differences In Movie Ratings
Calculate the average lifetime rating and rating from the movie with second biggest id across all actors and all films they had acted in. Remove null ratings from the calculation. Role type is "Normal Acting".
Output a list of actors, their average lifetime rating, rating from the film with the second biggest id (use id column), and the absolute difference between the two ratings.
Table(s): nominee_filmography, nominee_information
Last updated