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

with t1 as (SELECT DISTINCT rec_info_l,r.rec_user,hobby_l,score
from recommend_tb r
inner join user_action_tb u
on  r.rec_user  = u.user_id and rec_info_l = hobby_l
)
SELECT ROUND(AVG(score),3)  as  avg_score from t1;
#筛选出爱好和推荐相等的行，并去重