SELECT u.device_id, u.university, IFNULL( ( SELECT COUNT(q.question_id) FROM &...