with tiaojian as (
select 
distinct 
ub.user_id,
score
from recommend_tb tb inner join user_action_tb ub on tb.rec_user=ub.user_id and rec_info_l=hobby_l
group by tb.rec_user,ub.user_id, rec_info_l,hobby_l
)


select 
sum(score)/count( user_id)
from tiaojian