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;
点赞 评论

相关推荐

frutiger:逆天,我家就安阳的,这hr咋能说3k的,你送外卖不比这工资高得多?还说大厂来的6k,打发叫花子的呢?这hr是怎么做到说昧良心的话的
点赞 评论 收藏
分享
牛客383479252号:9,2学生暑期实习失利开始投小厂,给这群人整自信了
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务