select u.device_id,u.university, sum(case when MONTH(date)='08' then 1 else 0 end) as question_cnt, sum(case when MONTH(date)='08' and result='right' then 1 else 0 end) as right_question_cnt from user_profile as u left join question_practice_detail as q on u.device_id =q.device_id where u.university...