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

SELECT
    c.music_name
FROM follow AS a
INNER JOIN music_likes AS b ON a.follower_id = b.user_id
INNER JOIN music AS c ON b.music_id = c.id
WHERE a.user_id = 1
    AND b.music_id NOT IN 
        (SELECT music_id FROM music_likes WHERE user_id = 1)
GROUP BY c.music_name,c.id
ORDER BY c.id;