题解 | 推荐内容准确的用户平均评分
推荐内容准确的用户平均评分
https://www.nowcoder.com/practice/2dcac73b647247f0aef0b261ed76b47e
with t1 as(select distinct a.user_id,a.score from user_action_tb a join recommend_tb b on b.rec_user=a.user_id where concat(b.rec_info_l,b.rec_user)=concat(a.hobby_l,user_id)) select round(sum(score)/count(user_id),3) as avg_score from t1
，感觉有些诈骗短信就这么发的