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

# SELECT follower_id FROM follow WHERE user_id = 1;
# (SELECT DISTINCT music_id FROM misic_likes WHERE user_id in (SELECT follower_id FROM follow WHERE user_id = 1) where music_id != (SELECT music_id FROM music_likes WHERE user_id = 1) order by music_id asc) temp;
SELECT music_name FROM music 
WHERE
id IN                                   
(SELECT DISTINCT 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)) order by music_id asc)