51,396
社区成员




A1: select sum(trx_amt) as all_money1,
"区间1" as date //date 指区间1
from ac_tdl
where trx_dt between begin_date and end_date
group by date;
select all_money1,
"区间1"
from A1
union
select all_money2,
"区间2"
from A2
union
..
select all_money12,
"区间12"
from A12;
应该是这么写的,上面的少写了区间。