题解 | 网易云音乐推荐(网易校招笔试真题)
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
SELECT `music_name` FROM( 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))t JOIN music m ON t.`music_id`=m.`id` ORDER BY id;
