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