题解 | 推荐内容准确的用户平均评分
推荐内容准确的用户平均评分
https://www.nowcoder.com/practice/2dcac73b647247f0aef0b261ed76b47e
WITH accurate_tb AS(
SELECT DISTINCT(rec_user),score
FROM recommend_tb
FULL JOIN user_action_tb
ON user_id=rec_user
WHERE rec_info_l=hobby_l
)
SELECT ROUND(AVG(score),3) AS avg_sore
FROM accurate_tb
查看24道真题和解析