select round(avg(每个用户平均分),3) 用户平均评分 from ( select rec_user ,avg(score) 每个用户平均分 from recommend_tb join user_action_tb on rec_user = user_id where rec_info_l = hobby_l group by 1 ) a