题解 | 推荐内容准确的用户平均评分
推荐内容准确的用户平均评分
https://www.nowcoder.com/practice/2dcac73b647247f0aef0b261ed76b47e
SELECT ROUND(AVG(score), 3) AS avg_score
FROM (
SELECT DISTINCT u.user_id, u.score
FROM recommend_tb r
JOIN user_action_tb u
ON r.rec_user = u.user_id
WHERE r.rec_info_l = u.hobby_l
) AS t;
#sql刷题##sql笔试#
