- In compass, select the sample_mflix db
- Click '+' to create a new collection. Call it movies_popular (that way you still have the full movies collection)
- Menu bar: Collection -> Import Data
- Select cyf_mflix_movies_popular.json and import
-
Which 3 movies came out in 1978
-
Which 3 movies rated as PG came out in 2001
-
Which 4 movies with a metacritic score higher than 90 came out before 1950
-
Which 3 movies with a metacritic score higher than 90 came out in the 1990s
-
Which 3 movies from Iran have a metacritic score higher than 80
-
Which 4 movies from one of the Nordic Countries (Sweden, Norway, Finland, Iceland or Denmark) came out in 2011
-
Which 2 movies have included both Matt Damon and Julia Styles in the cast
-
Which movie has won 210 awards?
-
Which movie has more than 50 "rotten" reviews on rotten tomatoes, but was nominated for two Oscars
-
What are the 3 oldest movies in the database?
-
Which are the top 3 movies according to the number of "fresh" reviews on rotten tomatoes?
- What happens if I try to find the 5 movies with the lowest number of "fresh" reviews on rotten tomatoes? How can I work around that
-
What movies include a given actor in their cast? e.g. /filmsbyactor?actors=Tom%20Cruise
-
What movies came out in a given year (e.g. /filmsbyyear?year=1999)
-
What movies have a metacritic score in a range (e.g. /filmsbyscore?minscore=60&maxscore=80)
-
What movies include any of the given actors (e.g. /filmsbyactor?actors=Tom%Cruise,Matt&20Damon)
-
Write a search endpoint that optionally combines the simple endpoints (e.g. /film/search?actors=Tom%20Cruise&minscore=80 and /film/search?year=2005&maxscore=75)
-
What are the different kinds of "rated" categories that exist
-
Return the titles of the movies with the top 5 metacritic scores for a given "rated" category
-
How many movies have each of the different "rated" categories
-
What are the worst 5 movies by ratio of fresh to rotten reviews on rotten tomatoes, and that have at least 20 fresh and rotten reviews combined
-
Write a paginated endpoint to see all movies
-
Write an endpoint that allows searching for keywords (a single keyword) in descriptions (and/or titles)