w3resource

Retrieve movies with complete information and more than 1000 IMDb votes


Retrieve all movies from the 'movies' collection that have complete information and have received more than 1000 votes on IMDb.

Structure of 'movies' collection:

{
    _id: ObjectId("573a1390f29313caabcd42e8"),
plot: 'A group of bandits stage a brazen train hold-up, only to find a determined posse hot on their heels.',
genres: [ 'Short', 'Western' ],
runtime: 11,
cast: [
      'A.C. Abadie',
      "Gilbert M. 'Broncho Billy' Anderson",
      'George Barnes',
      'Justus D. Barnes'
    ],
poster: 'https://m.media-amazon.com/images/M/MV5BMTU3NjE5NzYtYTYyNS00MDVmLWIwYjgtMmYwYWIxZDYyNzU2XkEyXkFqcGdeQXVyNzQzNzQxNzI@._V1_SY1000_SX677_AL_.jpg',
title: 'The Great Train Robbery',
fullplot: "Among the earliest existing films in American cinema - notable as the first film that presented a narrative story to tell - it depicts a group of cowboy outlaws who hold up a train and rob the passengers. They are then pursued by a Sheriff's posse. Several scenes have color included - all hand tinted.",
languages: [ 'English' ],
released: ISODate("1903-12-01T00:00:00.000Z"),
directors: [ 'Edwin S. Porter' ],
rated: 'TV-G',
awards: { wins: 1, nominations: 0, text: '1 win.' },
lastupdated: '2015-08-13 00:27:59.177000000',
year: 1903,
imdb: { rating: 7.4, votes: 9847, id: 439 },
countries: [ 'USA' ],
type: 'movie',
tomatoes: {
viewer: { rating: 3.7, numReviews: 2559, meter: 75 },
fresh: 6,
critic: { rating: 7.6, numReviews: 6, meter: 100 },
rotten: 0,
lastUpdated: ISODate("2015-08-08T19:16:10.000Z")
    }
.....

Query:

db.movies.find({ "imdb.votes": { $gt: 1000 } })

Output:

{
    _id: ObjectId("573a1391f29313caabcd7472"),
plot: 'A con artist masquerades a Russian nobility and attempts to seduce the wife of an American diplomat.',
genres: [ 'Drama' ],
runtime: 117,
cast: [
      'Rudolph Christians',
      'Miss DuPont',
      'Maude George',
      'Mae Busch'
    ],
num_mflix_comments: 1,
poster: 'https://m.media-amazon.com/images/M/MV5BMTk2NDkxMTY1Nl5BMl5BanBnXkFtZTgwNDI1NDU5MTE@._V1_SY1000_SX677_AL_.jpg',
title: 'Foolish Wives',
fullplot: '"Count" Karanzim, a Don Juan is with his cousins in Monte Carlo, living from faked money and the money he gets from rich ladies, who are attracted by his charmes and his title or his militaristic and aristocratic behaviour. He tries to have success with Mrs Hughes, the wife of the new US ambassador.',
languages: [ 'English' ],
released: ISODate("1922-01-11T00:00:00.000Z"),
directors: [ 'Erich von Stroheim' ],
writers: [
      'Erich von Stroheim (story)',
      'Marian Ainslee (titles)',
      'Walter Anthony (titles)'
    ],
awards: { wins: 1, nominations: 0, text: '1 win.' },
lastupdated: '2015-09-05 00:00:37.817000000',
year: 1922,
imdb: { rating: 7.3, votes: 1777, id: 13140 },
countries: [ 'USA' ],
type: 'movie',
tomatoes: {
viewer: { rating: 3.7, numReviews: 1079, meter: 77 },
dvd: ISODate("2000-09-19T00:00:00.000Z"),
critic: { rating: 9, numReviews: 9, meter: 89 },
lastUpdated: ISODate("2015-09-15T17:02:32.000Z"),
rotten: 1,
production: 'Universal Pictures',
fresh: 8
    }
  }

Explanation:

The said query in MongoDBretrieves movies from the 'movies' collection that have complete information and have received more than 1000 votes on IMDb.

The find() method filters documents where the value of the 'imdb.votes' field is greater than 1000.

Improve this sample solution and post your code through Disqus.

Previous: Retrieve movies with complete information and "UNRATED" rating.
Next: Retrieve movies with complete information and IMDb rating higher than 7.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.