select round(avg(score),3) as avg_score from ( select distinct rec_info_l,rec_user,score from recommend_tb r left join user_action_tb u on r.rec_user = u.user_id where rec_info_l = hobby_l ) as u