我这样子写怎么就不太行呢 with too_table as ( select er.uid, avg(score) from exam_record as er join user_info as ui using (uid) join examination_info as ei using(exam_id) where ui.level='7' and ei.tag='SQL' and ei.difficulty='hard' group by uid having avg(score)>80 ) select t1.uid, count(distinct exam_id) exam_cnt, count(distinct question_id) question_cnt from too_table as t1 left join exam_record as er using(uid) and year(er.submit_time) = '2021' left join practice_record as pr using(uid) and year(pr.submit_time) = '2021' group by t1.uid order by exam_cnt asc, question_cnt desc;