select
avg(distinct score)
from
recommend_tb r
left join user_action_tb u on r.rec_user = u.user_id
where
rec_info_l = hobby_l

select
avg(distinct score)
from
recommend_tb r
left join user_action_tb u on r.rec_user = u.user_id
where
rec_info_l = hobby_l