Yash Sakhareliya - IT6A - 2203031080015

Assiement 1 - MongoDb

    1. db.Ass1.find({runtime:{$gt:150}},{title:1,_id:0})
    2. db.Ass1.find({rating:{$gt:8.5}},{title:1,_id:0})
    3. db.Ass1.find({year:{$gte:2000,$lte:2015}},{title:1,_id:0})
    4. db.Ass1.find({$or:[{boxOffice:{$lte:500}},{boxOffice:{$gte:1000}}]},{title:1,_id:0})

  2. db.Ass1.find({$and:[{director:"Christopher Nolan"},{isOscarWinner:{$exists:1}},{boxOffice:{$gt:700}},{streamingOn:{$in:["Netflix"]}}]},{title:1,_id:0})

  3. db.Ass1.find({ "specialFeatures.behindTheScenes": true, "specialFeatures.deletedScenes":true} ,{title:1,_id:0})

  4. db.Ass1.find( { $and : [ {cast: {$in:['Carrie-Anne Moss','Morgan Freeman']} }, {languages:{$exists:1}},{streamingOn:{$exists:1}}, {$expr:{$gte: [{$size:"$streamingOn"},2] } } ] },{title:1,_id:0})

  5. db.movies.updateOne({title:"Inception"}, {$addToSet:{languages:"Chinese"}})

  6. db.movies.updateMany({director:"Christopher Nolan"},{$addToSet:{cast:"Michael Caine"}})

  7. db.movies.updateMany({runtime:{$gt:140}},{$addToSet:{streamingOn:"Disney+"}})


  9. db.movies.deleteMany({ rating: { $lt: 8.0 } });