Template
single collection
multiple collections
mgodatagen
update
indexe
explain
Stage
Database
bson
mgodatagen
[{a:5,b:5,c:null},{a:3,b:null,c:8},{a:null,b:3,c:9},{a:1,b:2,c:3},{a:2,c:5},{a:3,b:2},{a:4},{b:2,c:4},{b:2},{c:6}]
Query
db.collection.find({$nor:[{a:{$exists:false}},{c:{$lt:5,$in:[null]}}]})
Result