题解 | 推荐内容准确的用户平均评分
推荐内容准确的用户平均评分
https://www.nowcoder.com/practice/2dcac73b647247f0aef0b261ed76b47e
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作用就是多次推荐正确只需要记录一次
