Database

[{"PartnerName":"Company A - Both Complete Equal","MarketExpertese1":[{"Sector":{"Code":1,"Label":"Sector 1"}},{"Sector":{"Code":2,"Label":"Sector 2"}}],"MarketExpertese2":[{"Sector":{"Code":1,"TotalDays":1}},{"Sector":{"Code":2,"TotalDays":1}}]},{"PartnerName":"Company B - 1 has more","MarketExpertese1":[{"Sector":{"Code":1,"Label":"Sector 1"}},{"Sector":{"Code":2,"Label":"Sector 2"}},{"Sector":{"Code":3,"Label":"Sector 3"}}],"MarketExpertese2":[{"Sector":{"Code":1,"TotalDays":1}},{"Sector":{"Code":2,"TotalDays":1}}]},{"PartnerName":"Company C - 2 has more","MarketExpertese1":[{"Sector":{"Code":1,"Label":"Sector 1"}},{"Sector":{"Code":2,"Label":"Sector 2"}}],"MarketExpertese2":[{"Sector":{"Code":1,"TotalDays":1}},{"Sector":{"Code":2,"TotalDays":1}},{"Sector":{"Code":3,"TotalDays":1}}]},{"PartnerName":"Company D - 1 has - 2 Null","MarketExpertese1":[{"Sector":{"Code":1,"Label":"Sector 1"}}],"MarketExpertese2":null},{"PartnerName":"Company E - 1 null - 2 has","MarketExpertese1":null,"MarketExpertese2":[{"Sector":{"Code":1,"TotalDays":1}}]},{"PartnerName":"Company F - Both Empty","MarketExpertese1":[],"MarketExpertese2":[]},{"PartnerName":"Company G - Both Null","MarketExpertese1":null,"MarketExpertese2":null}]

Query

db.collection.find()

Result