| Question | Query |
|---|---|
| Query 1.1 |
db.movies.find({runtime:{$gt:150}},{_id:false,title:true});
|
| Query 1.2 |
db.movies.find({rating:{$gt:8.5}},{_id:false,title:true});
|
| Query 1.3 |
db.movies.find({
year: { $gte: 2000, $lte: 2015 }
});
|
| Query 1.4 |
db.movies.find({
$or: [
{ boxOffice: { $lt: 500 } },
{ boxOffice: { $gt: 1000 } }
]
});
|
| Query 2 |
db.movies.find({
director: "Christopher Nolan",
isOscarWinner: true,
boxOffice: { $gt: 700 },
streamingOn: "Netflix"
});
|
| Query 3 |
db.movies.find({
"specialFeatures.behindTheScenes": true,
"specialFeatures.deletedScenes": true
});
|
| Query 4 |
db.movies.find({
$and: [
{ cast: { $in: ["Carrie-Anne Moss", "Morgan Freeman"] } },
{ languages: { $exists: true, $not: { $size: 0 } } },
{ streamingOn: { $exists: true, $size: { $gte: 2 } } }
]
});
|
| Query 5 |
db.movies.updateOne(
{ title: "Inception" },
{ $addToSet: { languages: "Chinese" } }
);
|
| Query 6 |
db.movies.updateMany(
{ director: "Christopher Nolan" },
{ $addToSet: { cast: "Michael Caine" } }
);
|
| Query 7 |
db.movies.updateMany(
{ runtime: { $gt: 140 } },
{ $addToSet: { streamingOn: "Disney+" } }
);
|
| Query 8 |
db.movies.find({
$and: [
{ genre: { $size: 2 } },
{ boxOffice: { $exists: true } },
{ specialFeatures: { $exists: false } }
]
});
|
| Query 9 |
db.movies.deleteMany({
rating: { $lt: 8.0 }
});
|
| Query 10 |
db.movies.updateMany(
{ year: { $lt: 2000 } },
{ $pull: { streamingOn: "Netflix" } }
);
|