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