| Query1 |
1.
db.movies.find({runtime:{$gt:150}},{_id:false,title:true}),
db.movies.find({rating:{$gt:8.5}},{_id:false,title:true}),
db.movies.find({$and:[{year:{$gt:2000,$lt:2015}}]},{_id:false,title:true}),
db.movies.find({$or:[{boxOffice:{$lt:500,$gt:1}}]},{_id:false,title:true}) |
| Query2 |
db.movies.find({director:"Christopher Nolan",isOscarWinner:true,boxOffice:{$gt:700},streamingOn:"Netflix"},{_id:false,title:true}) |
| Query3 |
db.movies.find({"specialFeatures.behindTheScenes":true,"specialFeatures.deletedScenes":true},{_id:false,title:true}) |
| Query4 |
db.movies.find( { $and : [ {cast: {$in:['Carrie-Anne Moss','Morgan Freeman']} }, {languages:{$exists:true}},{streamingOn:{$exists:true}}, {$expr:{$gte: [{$size:"$streamingOn"},2] } } ] },{title:true,_id:false}) |
| Query5 |
db.movies.updateOne({title:"Inception"}, {$addToSet:{languages:"Chinese"}}) |