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