join two tablesgroup by device_id and university, count question_idgroup by university, calculate the average of question_id select university, avg(count_question_id) as avg_answer_cnt from ( select device_id, university, count(question_id) as ...