Database
[{"_id":1,"City":"Los Angeles","State":"California","Details":[{"Name":"Shawn","age":"55","Gender":"Male","profession":" A science teacher with STEM","inDate":"2021-01-15 23:12:17","Cars":["BMW","Ford","Opel"],"language":"English"},{"Name":"Nicole","age":"21","Gender":"Female","profession":"Law student","inDate":"2021-01-16 13:45:00","Cars":["Opel"],"language":"English"}],"date":"2021-01-16"}]
Query
db.collection.find({"Details.Cars":"BMW","date":"2021-01-16"},{"Details":{"$elemMatch":{"Cars":"BMW"}}})