题解 | #满足条件的用户的试卷完成数和题目练习数#

代码通过了自测运行，但提交的时候通不过。蹲一个指导

    u.uid,
    count(distinct er.submit_time) as exam_cnt,
    count(distinct p.submit_time) as question_cnt
from
    user_info as u
    inner join exam_record as er on u.uid = er.uid
    inner join examination_info as ei on ei.exam_id = er.exam_id
    left join  practice_record as p on u.uid = p.uid
where
     u.uid in (
        select
            u.uid
        from
            user_info as u
            inner join exam_record as er on u.uid = er.uid
            inner join examination_info as ei on ei.exam_id = er.exam_id
        where
            ei.tag = "SQL"
            and ei.difficulty = "hard"
            and u.level = 7
            and year(er.submit_time) = 2021
            group by u.uid
            having(er.score)>80        
    )
group by
    u.uid
order by
    exam_cnt,
    question_cnt DESC