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

select  music_name from (select distinct c1.* from (select p2.music_id from follow as p1 left outer join music_likes as p2 on p1.follower_id=p2.user_id where p1.user_id =1) as c1 inner join music_likes as c2 on c1.music_id=c2.music_id where c2.music_id not in (select music_id from music_likes where user_id=1)) as c3 left outer join music as c4 on c3.music_id=c4.id order by c4.id;