var pipeline1 = [{$match:{ "imdb.rating": { $gte: 7 }, $nor: [{ "genre": "Crime" }, { "genre": "Horror" }], $or: [{ 'rated':"PG"}, { 'rated': "G" }], $and:[{ 'languages': "English"}, { 'languages': "Japanese" }] }}]
var pipeline = [{$match:{'imdb.rating':{$gte:7},genres:{$nin:['Crime','Horror']},rated:{$in:['PG','G']},'languages':{$all:['English','Japanese']}}}]
I hope the above two queries are similar but result is different can someone help me understand why?