select up.device_id,
       up.university,
       count(qpd.result) as question_cut,
       sum(if(qpd.result='right',1,0)) as right_question_cut
from user_profile as up
left join question_practice_detail qpd on up.device_id = qpd.device_id
where up.university='复旦大学' and (month(qpd.date)=8 or qpd.result is null ) group by up.device_id, up.university