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

SELECT 
    --  music.id,
    music.music_name 
FROM 
    follow 
JOIN 
    music_likes 
ON 
    follow.follower_id = music_likes.user_id
JOIN 
    music 
ON 
    music_likes.music_id = music.id 
WHERE 
    follow.user_id = 1 
AND 
    music_likes.music_id NOT IN ( SELECT DISTINCT music_id FROM music_likes WHERE user_id = 1 )
GROUP BY 
    music.id , music.music_name
ORDER BY 
    music.id