题解 | 推荐内容准确的用户平均评分
推荐内容准确的用户平均评分
https://www.nowcoder.com/practice/2dcac73b647247f0aef0b261ed76b47e
select round(avg(score),3) as avg_score
from
( select distinct rec_info_l,rec_user,score
from recommend_tb r
left join user_action_tb u on r.rec_user = u.user_id
where rec_info_l = hobby_l
) as u
文远知行公司福利 558人发布