题解 | 网易云音乐推荐(网易校招笔试真题)
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select
music_name
from
(select
mc.music_name
,mc.id
from (
select
*
from follow
where user_id=1
) f
left join music_likes m
on f.follower_id= m.user_id
left join music mc
on m.music_id = mc.id
where m.music_id not in (
select music_id
from music_likes
where user_id=1
)
group by mc.music_name,mc.id
order by mc.id asc ) t1
查看17道真题和解析