题解 | 网易云音乐推荐(网易校招笔试真题)注意distinct和orderby的使用条件

select music_name
from (
    select distinct music_name, music_id
from follow f join music_likes ml on f.follower_id=ml.user_id join music m on ml.music_id=m.id
where f.user_id=1 and (f.user_id,music_id) not in (
    select f.user_id, ml.music_id
    from follow f join music_likes ml on f.user_id=ml.user_id
)
) as m1
order by music_id asc;