[{"_id":ObjectId("5a934e000102030405000000"),"plate":"ABC123","tenant":"aq","timestamp":1.697407200001e+12},{"_id":ObjectId("5a934e000102030405000001"),"plate":"DEF456","tenant":"aq","timestamp":1.697407200002e+12},{"_id":ObjectId("5a934e000102030405000002"),"plate":"ABC123","tenant":"aq","timestamp":1.697407200003e+12},{"_id":ObjectId("5a934e000102030405000003"),"plate":"GHI789","tenant":"aq","timestamp":1.697407200004e+12},{"_id":ObjectId("5a934e000102030405000004"),"plate":"ABC123","tenant":"aq","timestamp":1.697407200005e+12},{"_id":ObjectId("5a934e000102030405000005"),"plate":"DEF456","tenant":"aq","timestamp":1.697407200006e+12},{"_id":ObjectId("5a934e000102030405000006"),"plate":"JKL012","tenant":"aq","timestamp":1.697407200007e+12}]

db.collection.aggregate([{"$match":{"$and":[{"tenant":"aq"},{"timestamp":{"$gte":1697407200000}},{"timestamp":{"$lte":1697580059999}}]}},{"$group":{"_id":"$plate"}},{"$sort":{"_id":1}},{"$skip":0},{"$limit":10}])