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

SELECT music_name
FROM (
SELECT DISTINCT t3.id,t3.music_name
FROM follow t1
LEFT JOIN music_likes t2 ON t1.follower_id=t2.user_id
LEFT JOIN music t3 ON t2.music_id=t3.id
WHERE t1.user_id=1 AND t3.music_name NOT IN (
    SELECT p.music_name
    FROM music_likes o
    LEFT JOIN music p ON o.music_id=p.id
    WHERE o.user_id=1
)
) AS subquery
ORDER BY id