select university,round(count(user_profile.device_id)/count(distinct (question_practice_detail.device_id)),4) avg_answer_cnt from user_profile,question_practice_detail where user_profile.device_id=question_practice_detail.device_id group by university order by university

京公网安备 11010502036488号