这题通过率怎么这么低?感觉没订单七难| #网易云音乐推荐#
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
SELECT m.music_name FROM follow f JOIN music_likes ml ON f.follower_id = ml.user_id JOIN music m ON ml.music_id = m.id WHERE ml.music_id not in ( SELECT ml.music_id FROM follow f JOIN music_likes ml ON f.user_id = ml.user_id WHERE f.user_id = 1 ) AND f.user_id = 1 GROUP BY m.id ORDER BY m.id