select b.device_id,university
,sum(if(month(a.date)=8,1,0))  question_cnt
,sum(if(month(a.date)=8 and result='right',1,0))  right_question_cnt
from question_practice_detail a
right join 
user_profile b
on a.device_id=b.device_id
where b.university='复旦大学'
group by b.device_id