如下图的合计sql怎么写答:pay_amount ,substring(max(CONVERT(varchar(100),time, 112) + cast(remain as varchar(10))),9,10) as remainfrom (select cd,name,balance,re_amount,0 as pay_amount,remain,time from 充值表union allselect cd,name,balance,0,pay_amount,remain,time from 消费表) t1group by cd,...