oracle统计sql

select a.*,b.dwmc from ( select bsc, count(*) cou, sum(decode(zt, '1', 1, 0)) zx, sum(decode(zt, '0', 1, 0)) zc, sum(decode(bj, '2', 1, 0)) rd, sum(decode(bj, '1', 1, 0)) ms,sum(decode(bj, '3', 1, 0)) sxbj, sum(decode(qtbj, '1', 1, 0)) bdq, sum(decode(qtbj, '2', 1, 0)) fc, sum(decode(qtbj, '3', 1, 0)) dy, sum(decode(qtbj, '4', 1, 0)) sgty, sum(decode(qtbj, '5', 1, 0)) sxtq  from hbc_veh where  zt != '2' group by bsc)a,pl_company b where a.bsc=b.dwbh

根据zt bj qtbj 以此统计 zt还不等于0