题解 | 推荐内容准确的用户平均评分

select round(avg(b.score),3) as avg_score from recommend_tb a

join user_action_tb b on

a.rec_user=b.user_id and a.rec_info_l=b.hobby_l