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