Database
[{"id":"A1","Name":"Anil","details":{"State":"INDIA","Address":[{"CITY":"BIHAR","region":null},{"CITY":"Delhi","region":null}],"DateTime":"2021-03-30T10:14:22.203Z"}},{"id":"A2","Name":"Sunil","details":{"State":"INDIA","Address":[{"CITY":"Banglore","region":null},{"CITY":"Delhi","region":null}],"DateTime":"2021-03-30T10:14:22.203Z"}},{"id":"A3","Name":"Kumar","details":{"State":"INDIA","Address":[{"CITY":"BIHAR","region":null},{"CITY":"assam","region":null}],"DateTime":"2021-03-30T10:14:22.203Z"}}]
Query
db.collection.find({"details.Address.CITY":"BIHAR"})