题解 | 网易云音乐推荐(网易校招笔试真题)
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
SELECT b.music_name
FROM music_likes AS a
JOIN music AS b ON a.music_id = b.id
WHERE a.user_id IN (SELECT follower_id FROM follow WHERE user_id = 1)
AND a.music_id NOT IN (
SELECT music_id
FROM music_likes
WHERE user_id = 1
)
GROUP BY b.music_name, b.id
ORDER BY b.id;
查看2道真题和解析