select round(avg(score),3) as avg_score from ( select rec_info_l, rec_user from recommend_tb group by 1,2 ) r inner join user_action_tb u on r.rec_user = u.user_id and r.rec_info_l = u.hobby_l ;