题解 | 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;
投递网易等公司10个岗位