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

select music_name
from
(select distinct id,music_name
from music
where id in
(select music_id
from music_likes
where user_id in (select follower_id from follow where user_id=1)
and music_id not in (select music_id from music_likes where user_id =1))) m
order by id;
比较有趣的是还要筛选掉用户本人喜欢的音乐，拆开一个个条件后，再组装到一起。比较喜欢In后面那个子查询。