业务需求
统计每天中支付宝充值总笔数和总金额及退款总笔数和总金额
select a.trandate as 交易日期 ,a.sm as 充值总金额,a.co as 充值总笔数,b.sm as 退款总金额 ,b.co as 退款总笔数 from
(select trandate,sum(tranamt) as sm,count(*) as co from mafedb.t_zjyw_tranrechis b where trancode ='2802' and transtat='00' group by trandate,trancode ) afull outer join
(select trandate,sum(tranamt) as sm,count(*) as co from mafedb.t_zjyw_tranrechis b where trancode ='2803' and transtat='00' group by trandate,trancode )b
on a.trandate=b.trandate order by a.trandate asc
select d.trandate,d.trancode,sum(tranamt),count(*) from mafedb.t_zjyw_tranrechis d where trancode in('2802','2803') and transtat ='00' group by trandate,trancode order by trandate asc