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