题解 | 推荐内容准确的用户平均评分
推荐内容准确的用户平均评分
https://www.nowcoder.com/practice/2dcac73b647247f0aef0b261ed76b47e
select avg(score) as avg_score from (select a.rec_info_l,a.rec_user, max(score) as score from recommend_tb a left join user_action_tb b on a.rec_user=b.user_id where a.rec_info_l=b.hobby_l group by 1,2 ) a
