Cacher is the code snippet organizer for pro developers

select
  (sum(ab.BALANCE) / '1')                    as DAILT_BALANCE,
  dbi.NO,
  dbi.ORG_NO,
  so.NAME,
  (sum(bi.AMOUNT_CDM + bi.AMOUNT_CWD) / '1') as TRAN_AMOUNT,
  (sum(bi.CDM_NUM + bi.CWD_NUM) / '1')       as COUNT
from DEV_BASE_INFO dbi left join ATM_BALANCE ab on dbi.NO = ab.DEV_NO
  left join BIZTXLOG_INIT bi on dbi.NO = bi.TERMID
  left join SYS_ORG so on dbi.ORG_NO = so.NO
where 1 = 1 and bi.TRANDATE = ab.REPORT_DATE and dbi.ORG_NO in (select NO
                                                                from SYS_ORG o1
                                                                where o1.LEFT >= ? and o1.RIGHT <= ?) and
      ab.REPORT_DATE >= ? and bi.TRANDATE >= ? and ab.REPORT_DATE <= ? and bi.TRANDATE <= ?
group by dbi.NO, dbi.ORG_NO, so.NAME
having 1 = 1
order by dbi.ORG_NO asc, dbi.NO asc