题解 | #推荐内容准确的用户平均评分#
推荐内容准确的用户平均评分
https://www.nowcoder.com/practice/2dcac73b647247f0aef0b261ed76b47e
select avg(score) avg_score from (select rec_user,sum(case when rec_info_l=hobby_l then 1 else 0 end) acc,avg(score) score from recommend_tb t1 join user_action_tb t2 on t1.rec_user=t2.user_id group by rec_user) t where acc!=0;