select round(avg(score),3) avg_score from( select distinct user_id, score from recommend_tb re join user_action_tb us on re.rec_user = us.user_id where rec_info_l = hobby_l ) as t1