select device_id, university, count(question_id) as question_cnt, sum(if(result='right',1,0)) as right_question_cnt from( select up.device_id, university, question_id, result, date from user_profile as up left join question_practice_detail as qpd on qpd.device_id=up.device_id where university='复旦大学'...