题解 | 浙大不同难度题目的正确率
浙大不同难度题目的正确率
https://www.nowcoder.com/practice/d8a4f7b1ded04948b5435a45f03ead8c
SELECT
qd2.difficult_level,
round(
count(case when qd1.result = 'right' then 1 end)/count(qd1.device_id)
,4) as correct_rate
FROM user_profile u
inner join question_practice_detail qd1
on u.device_id = qd1.device_id
inner join question_detail qd2
on qd1.question_id = qd2.question_id
where university = '浙江大学'
group by qd2.difficult_level
ORDER BY correct_rate;
蚂蚁集团一面260人在聊