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