select u.device_id,
        u.university,	
        count(q.question_id) as question_cnt,	
        sum(q.result='right') as right_question_cnt
from user_profile u
    left join question_practice_detail q
    on u.device_id=q.device_id 
where u.university = '复旦大学'
group by u.device_id