MongoDB Queries
Alisha kaur
Enrollment no. 2203031080202
Query1
1. db.movies.find({runtime:{$gt:150}})
db.movies.find({rating:{$gt:8.5}})
db.movies.find({$and:[{year:{$gt:2000,$lt:2015}}]})
Query2
2. db.movies.find({
director: "Christopher Nolan",
isOscarWinner: true,
boxOffice: { $gt: 700 },
streamingOn: "Netflix"
})
Query3
3. db.movies.find({
"specialFeatures.behindTheScenes": true,
"specialFeatures.deletedScenes": true
})
Query4
4. db.movies.find({
$or: [
{ cast: "Carrie-Anne Moss" },
{ cast: "Morgan Freeman" }
],
languages: { $exists: true },
"streamingOn.1": { $exists: true }
})
Query5
5. db.movies.updateOne(
{ title: "Inception" },
{ $set: { languages: "Chinese" } }
)
Query6
6. db.movies.updateMany(
{ director: "Christopher Nolan" },
{ $set: { cast: "Michael Caine" } }
)
Query7
7. db.movies.updateMany(
{ runtime: { $gt: 140 } },
{ $set: { streamingOn: "Disney+" } }
)
Query8
8. db.movies.find({
genre: { $size: 2 },
boxOffice: { $exists: true },
specialFeatures: { $exists: false }
})
Query9
9. db.movies.deleteMany({ rating: { $lt: 8.0 } });
Query10
10. db.movies.updateMany(
{ year: { $lt: 2000 } },
{ $pull: { streamingOn: "Netflix" } }
);
Query11
11. db.movies.find({
$expr: { $gt: ["$boxOffice", { $multiply: ["$runtime", 10] }] }
});
Query13
13. db.movies.find({ genre: { $all: ["Action", "Sci-Fi"] } });
Query14
14. db.movies.find({ "genre.0": "Action" });
Query15
15. db.movies.find({ cast: { $size: 3 } });
Progress: 13/15
86%