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