题解 | #网易云音乐推荐(网易校招笔试真题)#
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
# 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)