题解 | 推荐内容准确的用户平均评分
推荐内容准确的用户平均评分
https://www.nowcoder.com/practice/2dcac73b647247f0aef0b261ed76b47e
select
avg(score) as avg_score
from
(
select
distinct rec_user,
rec_info_l,
hobby_l,
score
from
recommend_tb rt
left join user_action_tb ut
on rt.rec_user = ut.user_id
where rec_info_l = hobby_l
) a
;
