题解 | 网易云音乐推荐(网易校招笔试真题)

SELECT music_name
FROM (
    SELECT DISTINCT ml.music_id, m.music_name
FROM follow f
JOIN music_likes ml ON f.follower_id = ml.user_id
JOIN music m ON ml.music_id = m.id
WHERE f.user_id = 1
AND ml.music_id NOT IN(
    SELECT ml1.music_id
    FROM music_likes ml1
JOIN music m1 ON ml1.music_id = m1.id
WHERE ml1.user_id = 1

)
) co
ORDER BY music_id