{"_id":"14139e126137625f0a8b0a4c3302e3f1","ordertimes":2,"mobile":"11111111111","month":"2021-09"}
{"_id":"14139e126137625f0a8b0a4d0bfdd883","ordertimes":1,"mobile":"11111111111","month":"2021-08"}
{"_id":"14139e126137625f0a8b0a4e4d80ff30","ordertimes":4,"mobile":"11111111111","month":"2021-07"}
{"_id":"14139e126137625f0a8b0a4f134e77c9","ordertimes":7,"mobile":"11111111111","month":"2021-06"}
{"_id":"14139e126137625f0a8b0a4c3302e3f2","ordertimes":1,"mobile":"22222222222","month":"2021-09"}
{"_id":"14139e126137625f0a8b0a4d0bfdd884","ordertimes":0,"mobile":"22222222222","month":"2021-08"}
{"_id":"14139e126137625f0a8b0a4e4d80ff36","ordertimes":0,"mobile":"22222222222","month":"2021-07"}
{"_id":"14139e126137625f0a8b0a4f134e77c8","ordertimes":0,"mobile":"22222222222","month":"2021-06"}
上面这个表:表示用户(手机号)在每个月的支付订单数量,即
{"_id":"14139e126137625f0a8b0a4c3302e3f1","ordertimes":2,"mobile":"11111111111","month":"2021-09"}
表示,手机用户11111111111在2021-09月份,订单数量为2。
想要查询:
当月(2021-09)支付过1次(ordertimes=1),其他月份没有支付过(ordertimes=0)的用户数量。