题解 | 推荐内容准确的用户平均评分
推荐内容准确的用户平均评分
https://www.nowcoder.com/practice/2dcac73b647247f0aef0b261ed76b47e
with
temp as (
select distinct
user_id,
score
from
recommend_tb r
join user_action_tb u on u.user_id = r.rec_user
where
rec_info_l = hobby_l
)
select
sum(score) / count(*) as avg_score
from
temp;
