题解 | 推荐内容准确的用户平均评分

select round(avg(t.score),3) as avg_score
from(
select distinct t2.score as score
from recommend_tb as t1
inner join user_action_tb as t2
on t1.rec_user = t2.user_id and t1.rec_info_l = t2.hobby_l
) as t;

全部评论

相关推荐

评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务