select university , count(q.question_id)/count(distinct(q.device_id)) avg_answer_cnt  
from 
user_profile u,question_practice_detail q where 
 u.device_id=q.device_id 
group by university

平均答题数=答题总数/总答题人数（去重）

from后可以跟多个表