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