WITH RankedPurchases AS ( SELECT user_id, level, amount, ROW_NUMBER() OVER (PARTITION BY level ORDER BY SUM(amount) DESC) AS rn FROM purchases GROUP BY user_id, level ) SELECT user_id, level, amount FROM RankedPurchases WHERE rn <= 10;
点赞 评论

相关推荐

点赞 评论 收藏
分享
牛客ID:561366855:期望薪资多少?难以相信这简历找不到工作。说明二本电子信息专业想对口就业非常难。
点赞 评论 收藏
分享
牛客网
牛客企业服务