select a1.university, round(question_id_count / device_id_count, 4) as avg_round from ( select tt1.university, count(distinct (device_id)) as device_id_count, count(question_id) as question_id_count from ( select t1.university, t2.question_id, t1.device_id from ( select * from user_profile ) t1 join...