题解 | #网易云音乐推荐(网易校招笔试真题)#
网易云音乐推荐(网易校招笔试真题)
http://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select music_name
from music
where id in(
select distinct music_id
from follow f left join music_likes ml on f.follower_id=ml.user_id
where f.user_id=1 and music_id not in(select music_id from music_likes where user_id=1)
)