SELECT *, CASE WHEN 排名 <=3 THEN 订单数 * 50+1000 WHEN 排名 BETWEEN 4 AND 10 THEN 订单数 * 50 ELSE 0 END AS "奖金" FROM ( SELECT cust_name, SUM( price ) AS "交易总额", COUNT( price ) "订单数", RANK() over ( ORDER BY SUM( price ) DESC ) AS "排名" FROM bankcall WHERE SUBSTR( order_add_time, 1, 7 ) = SUBSTR( now(), 1, 7 ) GROUP BY cust_name ) AS a WHERE 排名<=10
点赞 1

相关推荐

06-28 18:19
已编辑
门头沟学院 Java
查看32道真题和解析
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务