select round(avg(score), 3) as avg_score from ( select rec_info_l, rec_user from recommend_tb group by rec_info_l, rec_user ) a join user_action_tb b on a.rec_user=b.user_id where a.rec_info_l=b.hobby_l