with right_hobby_l as (select  
max(score) score
from recommend_tb r
left join user_action_tb u
on r.rec_user = u.user_id
where rec_info_l = hobby_l
group by r.rec_user)
select
avg(score)
from right_hobby_l