题解 | 推荐内容准确的用户平均评分
推荐内容准确的用户平均评分
https://www.nowcoder.com/practice/2dcac73b647247f0aef0b261ed76b47e
SELECT
round(avg(score),3) as avg_score
FROM
(
SELECT DISTINCT
rec_info_l,
rec_user,
score
FROM
recommend_tb r,
user_action_tb u
WHERE
r.rec_info_l = u.hobby_l
AND r.rec_user = u.user_id
) t
查看4道真题和解析