Database
[{"VIN":100,"CUSTOMER_TYPE":"1-PRIMARY BORROWER","CUSTOMER_FIRST_NAME":"MATT","DEAL_TYPE":"LEASE","CONTRACT_START_DATE":"04/30/2021"},{"VIN":101,"CUSTOMER_TYPE":"1-PRIMARY BORROWER","CUSTOMER_FIRST_NAME":"JOHN","DEAL_TYPE":"LEASE","CONTRACT_START_DATE":"04/30/2021"},{"VIN":103,"CUSTOMER_TYPE":"6-CO BORROWER","CUSTOMER_FIRST_NAME":"SUSAN","DEAL_TYPE":"LEASE","CONTRACT_START_DATE":"04/30/2022"},{"VIN":100,"CUSTOMER_TYPE":"1-PRIMARY BORROWER","CUSTOMER_FIRST_NAME":"MATT","DEAL_TYPE":"RETAIL","CONTRACT_START_DATE":"04/30/2022"}]
Query
db.collection.aggregate([{$group:{_id:"$VIN",data:{$push:"$$ROOT"},count:{$sum:1}}},{$match:{count:{$gt:1}}},{$unwind:"$data"},{$replaceRoot:{newRoot:"$data"}}])