题解 | 推荐内容准确的用户平均评分
with temp as (
select
b.user_id,
hobby_l,
score
from recommend_tb a inner join user_action_tb b
on a.rec_user=b.user_id and a.rec_info_l = b.hobby_l
group by b.user_id,hobby_l,score)
select
round(sum(score)/count(user_id),3) as avg_score
from
temp