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 as device_id, UP.university as university, QPD.question_id as question_id, QPD.re...