题解 | SQLW8 推荐内容准确的用户平均评分
WITH t1 AS (
SELECT user_id,
score
FROM recommend_tb a
LEFT JOIN user_action_tb b
ON a.rec_user = b.user_id
WHERE rec_info_l = hobby_l
GROUP BY user_id, score
)
SELECT ROUND(avg(score),3) AS avg_score
FROM t1;
三奇智元机器人科技有限公司公司福利 50人发布