Filter – {title : "Centennial"}
Sort - {runtime: -1} --- to sort by runtime in desc order
Project – {title:1, fullplot:1} -- to display specific fields
db.embedded_movies.find( { title: "From Hand to Mouth"} )
db.embedded_movies.find({}, {title:1, runtime:1})
db.embedded_movies.find({}, {_id:0, title:1})
db.embedded_movies.updateOne({title: "Jungle Book"}, {$set: {runtime:0}})
db.embedded_movies.find({title: "Jungle Book"}, {title: 1, runtime: 1})
db.embedded_movies.find({genres: {$in: ["Action"]}}, {title:1, genres:1} )
db.embedded_movies.aggregate([
{ $match: { runtime: { $gt: 500 } } }, // Match documents with runtime greater than 500
{ $project: { title: 1, runtime: 1, year: 1 } } // Select specific fields: title, runtime, year
])
db.embedded_movies.aggregate([
{$match: {runtime: {$gt: 500}}},
{$group: {_id: "$year", totalruntime: {$sum: "$runtime"}}},
])
db.embedded_movies.aggregate([ {$sort: {runtime:-1}}, {$limit: 1}])
db.embedded_movies.aggregate([ {$sort: {runtime:-1}}, {$limit: 1}, {$project:
{title:1, year:1, runtime:1}}])
db.embedded_movies.aggregate([
{$match: {genres: {$in: ["Action"]}}},
{$project: {title:1, genres:1}}
])
db.embedded_movies.aggregate([
{$match: {genres: {$all: ["Action", "Comedy"]}}},
{$project: {title:1, genres:1}}
])
db.embedded_movies.aggregate([
{$match: {genres: {$all: ["Action", "Comedy"]}}},
{$count: "totalMovies"}
])