题解 | #推荐内容准确的用户平均评分#
推荐内容准确的用户平均评分
https://www.nowcoder.com/practice/2dcac73b647247f0aef0b261ed76b47e
with a1 as ( select distinct r.rec_user ,u.score from recommend_tb r left join user_action_tb u on r.rec_user = u.user_id where r.rec_info_l=u.hobby_l ) select avg(score) from a1