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

select
    avg(score)
from
    (
        select
        distinct user_id,
        score
        from
            recommend_tb AS rt
            JOIN user_action_tb as u on rt.rec_user = u.user_id and
            rt.rec_info_l = u.hobby_l
    ) as a