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