题解 | #浙大不同难度题目的正确率#
浙大不同难度题目的正确率
https://www.nowcoder.com/practice/d8a4f7b1ded04948b5435a45f03ead8c
select difficult_level, round(sum(case result when 'right' then 1 else 0 end )*1.0/sum(1),4) correct_rate from user_profile a join question_practice_detail b on a.device_id = b.device_id join question_detail c on c.question_id = b.question_id where a.university = "浙江大学" group by difficult_level order by correct_rate asc#sql##sql练习日常#
SQL练习 文章被收录于专栏
SQL练习
