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

select music_name
from
(SELECT distinct music_name,music_id
FROM
(SELECT *
FROM
(
SELECT follower_id
FROM follow
WHERE user_id = 1
) AS t1 LEFT JOIN music_likes AS t2
ON t1.follower_id = t2.user_id
WHERE music_id NOT IN (SELECT music_id FROM music_likes WHERE user_id = 1)
order by music_id asc
) AS t3 JOIN music
ON t3.music_id = music.id
order by music_id) as t4