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

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

https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7

SELECT m.music_name
FROM (
	SELECT music_id
	FROM (
		SELECT DISTINCT music_id
		FROM music_likes
		WHERE user_id IN (
			SELECT follower_id
			FROM follow
			WHERE user_id = 1
		)
	) t 
	WHERE music_id NOT IN (
		SELECT music_id
		FROM music_likes
		WHERE user_id = 1
	)
) t1 JOIN music m ON  t1.music_id = m.id
ORDER BY t1.music_id

全部评论

相关推荐

点赞 收藏 评论
分享
牛客网
牛客企业服务