题解 | #推荐内容准确的用户平均评分#
推荐内容准确的用户平均评分
https://www.nowcoder.com/practice/2dcac73b647247f0aef0b261ed76b47e
WITH correct AS(
SELECT DISTINCT rt.rec_user, ut.hobby_l, ut.score
FROM recommend_tb AS rt
LEFT JOIN user_action_tb AS ut
ON rt.rec_user = ut.user_id
WHERE rt.rec_info_l = ut.hobby_l
)
SELECT avg(correct.score) AS avg_score
FROM correct;
