题解 | #浙大不同难度题目的正确率#
浙大不同难度题目的正确率
https://www.nowcoder.com/practice/d8a4f7b1ded04948b5435a45f03ead8c
select
difficult_level,
count(case when result='right' then 1 else null end) / count(t1.question_id) as correct_rate
from question_practice_detail t1 left join question_detail t2 on t1.question_id=t2.question_id
left join user_profile t3 on t1.device_id =t3.device_id and t3.university='浙江大学'
where t3.university='浙江大学'
group by difficult_level
order by correct_rate asc
查看30道真题和解析