select
device_id
,university
,count(question_id) as question_cnt
,count(case when result='right' then 1 end) as right_question_cnt
from question_practice_detail
left join user_profile
using(device_id)
where university='复旦大学'
group by 1