题解 | 推荐内容准确的用户平均评分

select avg(score) from(
select distinct user_id,score
from recommend_tb rt
inner join user_action_tb uat
on uat.user_id = rt.rec_user
where hobby_L = rec_info_L) as t1