题解 | #浙大不同难度题目的正确率#
浙大不同难度题目的正确率
https://www.nowcoder.com/practice/d8a4f7b1ded04948b5435a45f03ead8c
1
select difficult_level,sum(if(result='right',1,0))/count(q1.question_id) correct_rate
2
from user_profile u
3
inner join question_practice_detail q1
4
on u.device_id = q1.device_id
5
inner join question_detail q2
6
on q1.question_id = q2.question_id
7
where university = '浙江大学'
8
group by difficult_level
9
order by correct_rate
运行结果自测输入提交记录
