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