写点不一样的解法 uid, exam_complete_cnt from ( select r.uid, sum(submit_time is not null) exam_complete_cnt from exam_record r where (uid, date_format(start_time, '%Y-%m')) in ( select uid, `month` from ( select uid, `month`, `rank` from ( select uid, date_format(start_time, '%Y-%m') `month`, dense_rank() ...
