with result as (select * from QG_CXRY_JBXX left join QG_CXRY_CX on QG_CXRY_CX.RYID = QG_CXRY_JBXX.RYID where QG_CXRY_JBXX.RBKSJ_CX > to_date('2014/7/1 0:00:00','yyyy-mm-dd hh24:mi:ss') and QG_CXRY_JBXX.RBKSJ_CX < to_date('2014/7/23 0:00:00','yyyy-mm-dd hh24:mi:ss'))
select '长春' as area,'总数',count(1) from result where ZH_DWDM like '2201%'
select '长春' as area,'总数',count(1) from result where ZH_DWDM like '2201%'