Question

Instructions:For questions 1-8, use MongoDB Compass and open the movieDB, and open the movie collection to answer the questions below. Include the query used (make sure to include all stages) and the results of the query.

PLEASE ANSWER ALL QUESTIONS FOR POSITIVE FEEDBACK AND THUMBS UP

Here is an example of what a document in this collection looks like (JSON Pretty Print): Moviedb.list { "_id": {     "$oid": "573a1392f29313caabcd9caa" }, "plot": "Many passengers on the Shanghai Express are more concerned that the notorious Shanghai Lil is on board than the fact that a civil war is going on that may make the trip take more than three...", "genres": [     "Adventure",     "Drama",     "Romance" ], "runtime": 82, "cast": [     "Marlene Dietrich",     "Clive Brook",     "Anna May Wong",     "Warner Oland" ], "title": "Shanghai Express", "released": {     "$date": "1932-02-12T00:00:00.000Z" }, "year": 1932, "imdb": {     "rating": 7.5,     "votes": 4288,     "id": 23458 }, "tomatoes": "573a1392f29313caabcd0031" } Movie.rotton { "_id": {     "$oid": "573a1392f29313caabcd0031" },     "viewer": {       "rating": 3.9,       "numReviews": 1452,       "meter": 82     },     "dvd": {       "$date": "1993-10-20T00:00:00.000Z"     },     "critic": {       "rating": 8.6,       "numReviews": 15,       "meter": 100     },     "lastUpdated": {       "$date": "2015-09-10T19:14:21.000Z"     },     "rotten": 0,     "production": "Paramount Pictures",     "fresh": 15 }

How many movies have an Imdb rating greater than 5 and more than 1500 votes?

Of the films that have 3 genres and feature Paul Muni, what is the total runtime of these films, grouped by year?

What are the titles of the 2 films that have the highest rotten tomatoes critic meters? Return title and critic meters of the films.

Return the average imdb rating by genres among films that feature Kathryn McGuire and Buster Keaton. Present the results based on lowest to highest average rating.

What is the average runtime of movies that have 3 genres, have a runtime less than 100 minutes, and have a year greater than 1932? (hint: arrays start with the number 0)

What is the number of rotten tomatoes viewer reviews on the oldest film in the database? Return the title and number of rotten tomato viewer reviews,

How many films feature Lillian Gish and have over 3,000 viewer reviews on Rotten Tomatoes?

Of the films that feature Paul Robeson, return the 2 films with the lowest imdb rating. Return the imdb rating and title of the films.

Open the moviedb.list collection. Provide the query for connecting the rotten collection to the list collection, in order to join the two.