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