SELECT
AVG(score)
FROM
(
SELECT DISTINCT
rec_info_l,
rec_user,
score
FROM
recommend_tb r,
user_action_tb u
WHERE
r.rec_info_l = u.hobby_l
AND r.rec_user = u.user_id
) t

京公网安备 11010502036488号