题解 | 网易云音乐推荐(网易校招笔试真题)
with T as(select distinct(music_id) from music_likes where user_id=1) select music_name from music where id in (select distinct(music_likes.music_id) as id from follow,music_likes where follow.follower_id=music_likes.user_id and music_likes.music_id not in(select * from T) and follow.user_id=1) order by id
