Mysql-使用avg()与if()函数计算正确率

Mysql-使用avg()与if()函数计算正确率

计算上表中不同难度的题目答题准确率。

SELECT difficult_level,
AVG(IF(result='right',1,0)) AS correct_rate,
AVG(IF(result='wrong',1,0)) AS wrong_rate
FROM user_profile u,
 question_practice_detail qpd, 
 question_detail qd
WHERE u.device_id = qpd.device_id AND qpd.question_id = qd.question_id
GROUP BY difficult_level
ORDER BY correct_rate;