题解 | 网易云音乐推荐(网易校招笔试真题)
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
SELECT m.music_name
FROM music m
WHERE EXISTS (
SELECT 1
FROM follow f
JOIN music_likes ml ON f.follower_id = ml.user_id
WHERE f.user_id = 1
AND ml.music_id = m.id
)
AND NOT EXISTS (
SELECT 1
FROM music_likes self
WHERE self.user_id = 1
AND self.music_id = m.id
)
查看24道真题和解析
百度公司福利 621人发布