题解 | 推荐内容准确的用户平均评分
SELECT
AVG(DISTINCT ut.score) avg_score
FROM recommend_tb rt
JOIN user_action_tb ut ON rt.rec_user = ut.user_id AND rt.rec_info_l = ut.hobby_l
GROUP BY SUBSTR(rec_time,1,10)
SELECT
AVG(DISTINCT ut.score) avg_score
FROM recommend_tb rt
JOIN user_action_tb ut ON rt.rec_user = ut.user_id AND rt.rec_info_l = ut.hobby_l
GROUP BY SUBSTR(rec_time,1,10)
相关推荐