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

select round(avg(distinct score),3) avg_acore
from recommend_tb r join user_action_tb u on r.rec_user = u.user_id
and rec_info_l = hobby_l
# 注意要加上distinct