题解 | #浙大不同难度题目的正确率#
浙大不同难度题目的正确率
http://www.nowcoder.com/practice/d8a4f7b1ded04948b5435a45f03ead8c
SELECT difficult_level,SUM(if(result='right',1,0))/COUNT(difficult_level) as correct_rate FROM question_detail,question_practice_detail,user_profile WHERE question_detail.question_id=question_practice_detail.question_id and question_practice_detail.device_id=user_profile.device_id and user_profile.university = '浙江大学' GROUP BY difficult_level order by correct_rate
查看14道真题和解析
