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

SELECT m.music_name
FROM (
	SELECT music_id
	FROM (
		SELECT DISTINCT music_id
		FROM music_likes
		WHERE user_id IN (
			SELECT follower_id
			FROM follow
			WHERE user_id = 1
		)
	) t 
	WHERE music_id NOT IN (
		SELECT music_id
		FROM music_likes
		WHERE user_id = 1
	)
) t1 JOIN music m ON  t1.music_id = m.id
ORDER BY t1.music_id