select device_id, '复旦大学' as university, coalesce(count(question_id), 0), sum(if (result = 'right', 1, 0)) from ( select u.device_id, q.question_id, q.result from user_profile u join question_practice_deta...