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

select
music_name
from
(select
m.id,
m.music_name
from
follow as f inner join music_likes as ml
on f.follower_id = ml.user_id
inner join music as m 
on ml.music_id = m.id
where f.user_id = 1 and m.music_name not in(
    select
    m.music_name
    from
    follow as f inner join music_likes as ml
    on f.user_id = ml.user_id
    inner join music as m 
    on ml.music_id = m.id 
    where f.user_id = 1
)) as t group by music_name order by max(id)

思路：不能同时使用distinct和order by，使用group by代替