这题通过率怎么这么低?感觉没订单七难| #网易云音乐推荐#

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

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

全部评论
哥 能帮我看看这个错在哪里吗 SELECT music_name FROM follow f JOIN music_likes ml ON f.user_id = ml.user_id JOIN music m ON ml.music_id = m.id WHERE ml.user_id in ( select follower_id from follow where user_id = 1) and ml.music_id not in (select music_id from music_likes where user_id = 1) GROUP BY m.id ORDER BY m.id
点赞 回复 分享
发布于 2024-09-20 00:07 广东

相关推荐

点赞 评论 收藏
分享
allin秋招的大菠萝很爱交友:后续,已拿offer ~查看图片
点赞 评论 收藏
分享
评论
1
收藏
分享

创作者周榜

更多
牛客网
牛客企业服务