描述
题目: 现在运营想要了解复旦大学的每个用户在8月份练习的总题目数和回答正确的题目数情况,请取出相应明细数据,对于在8月份没有练习过的用户,答题数结果返回0.
示例:用户信息表user_profile
根据示例,你的查询应返回以下结果:
SELECT
u.device_id,
university,
SUM(IF(result IS NOT NULL, 1, 0)) AS questino_cnt,
SUM(IF(result = "right", 1, 0)) AS right_question_cnt
FROM
user_profile u
LEFT JOIN question_practice_detail q
ON u.device_id = q.device_id
AND MONTH(q.`date`) = "