Download the movies.json dataset and add it to a new collection
Q1. Find all movies with full information from the 'movies' collection that
- were released in the year 1893.
- have a runtime greater than 120 minutes
- have "Short" genre.
- were directed by "William K.L. Dickson"
- were released in the USA
- are rated as "UNRATED"
Q2. Find the names of all movies that have
- have received more than 1000 votes on IMDb
- have an IMDb rating higher than 7
- viewer rating higher than 4 on Tomatoes
- have received an award
Q3. Find all movies with title, languages, released, directors, writers, awards, year, genres, runtime, cast, countries that:
- have at least one nomination
- have a case including "Charles Kayser".
- were released on May 9, 1893
- have a word "scene" in the title
Q4. Find all movies with title, languages, released, directors, viewer, writers, countries that have a viewer rating of at least 3 and less than 4 on Tomatoes.
Q5. Retrieve all movies with title, languages, released, year, directors, writers, countries that released before the year 1900.
Q6. Find all movies with title, languages, fullplot, released, directors, writers, countries from the 'movies' collection in MongoDB that have a fullplot containing the word "fire".
Q7. Return all movies with title, languages, plot, released, directors, writers, and countries where the word "beer" mentioned in the plot.
Q8. Return all movies with title, languages, fullplot, released, directors, writers, and countries where the word "metal" mentioned in the fullplot.
Q9. Find all movies with title, languages, released, runtime, directors, writers, countries that have a runtime between 60 and 90 minutes.
Q10. Find the top 5 highest IMDb ratings and display their title, languages, released, runtime, directors
Q11. Find the average runtime of movies released in each country.
Q12. Find the most common genre among the movies.
Q13. Find the movies released in the year with the highest average IMDb rating
Q14. Find the top 10 directors with the most movies
Q15. Find the movies with different ratings (e.g., 'PG', 'R', 'G')
Q16. Find the oldest movie with an award win