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

with temp as (
    select 
        distinct
        rt.rec_user
        from recommend_tb rt
        inner join user_action_tb uat
        on uat.user_id = rt.rec_user
        where rt.rec_info_l = uat.hobby_l
)
select 
    round(avg(uat.score),3) as avg_score
    from user_action_tb uat
    inner join temp tp
    on tp.rec_user = uat.user_id

distinct作用就是多次推荐正确只需要记录一次