题解 | #满足条件的用户的试卷完成数和题目练习数#
满足条件的用户的试卷完成数和题目练习数
https://www.nowcoder.com/practice/5c03f761b36046649ee71f05e1ceecbf
有没有大佬可以帮忙看看我这么些到底哪里出了问题
select exam_record.uid,count(distinct exam_record.id) exam_cnt,count(distinct practice_record.id) question_cnt from exam_record left join practice_record on exam_record.uid = practice_record.uid
where exam_record.uid in
(select exam_record.uid from user_info left join exam_record on user_info.uid = exam_record.uid
where exam_id = '9001' and level = '7' and year(submit_time) =2021
group by user_info.uid
having avg(score) > 80)
group by exam_record.uid
order by exam_cnt asc,question_cnt desc
投递海康威视等公司7个岗位