SELECT RECHARGE_DATE,OPERATORS_SID,count(1) as 总数,
SUM(CASE WHEN RECHARGE_STATUS =1 THEN 1 ELSE 0 END) as 成功数量,
SUM(CASE WHEN RECHARGE_STATUS =0 THEN 1 ELSE 0 END) as 失败数量,
SUM(CASE WHEN RECHARGE_STATUS =1 THEN ORDER_PRICE ELSE 0 END) as 消费金额
from tb_recharge_log
SUM(CASE WHEN RECHARGE_STATUS =1 THEN 1 ELSE 0 END) as 成功数量,
SUM(CASE WHEN RECHARGE_STATUS =0 THEN 1 ELSE 0 END) as 失败数量,
SUM(CASE WHEN RECHARGE_STATUS =1 THEN ORDER_PRICE ELSE 0 END) as 消费金额
from tb_recharge_log