select aa.device_id,university ,(select count(a.question_id) from question_practice_detail a where month(a.date) = 8 and a.device_id = aa.device_id ) question_cnt ,(select count(a.result) from questi...