with
t1 as(
    select distinct
        rec_user,
        score
    from
        recommend_tb as rt
        left join user_action_tb as uat
        on rec_user = user_id
    where
        rec_info_l = hobby_l
)
,t2 as(
    select
        avg(score)
    from
        t1
)

select * from t2