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

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