WITH ShandongUsers AS ( SELECT device_id, university, answer_cnt FROM user_profile WHERE university = '山东大学' ) SELECT su.university, difficult_level, COUNT(answer_cnt) / COUNT(DISTINCT su.device_id) FROM ShandongUsers AS su JOIN question_practice_detail AS qpd ON su.device_id = qpd.devi...
