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