Database
[{"name":"AdventNet","Offices":[{"Description":"Headquarters","city":"San Francisco"},{"Description":"Headquarters1","city":"San Francisco"}]},{"name":"B","Offices":[{"Description":"Headquarters","city":"San F"},{"Description":"Headquarters1","city":"San Francisco"}]}]
Query
db.collection.aggregate([{$match:{"Offices.city":"San Francisco"}},{$set:{haveOfficeInCIty:{$size:{$filter:{input:"$Offices",as:"office",cond:{$eq:["$$office.city","San Francisco"]}}}}}},{$match:{haveOfficeInCIty:{$eq:2}}}])