CREATE OR REPLACE PROCEDURE 存储过程名字 IS
BEGIN
END
select PROVINCE_NAME,CITY_NAME,COUNTY_NAME,t1.COUNTY_CODE,ALREADY_OPENED,REGISTRATION_ENTRY from
(select distinct PROVINCE_NAME ,PROVINCE_CODE,CITY_NAME,COUNTY_NAME,COUNTY_CODE from DW_LC_USER order by PROVINCE_CODE) t1
left join (select COUNTY_CODE,min(COUNTY_NAME),sum(decode(OPERATE_STATUS,'已开通',1,0)) ALREADY_OPENED ,count(*) REGISTRATION_ENTRY from DW_LC_USER group by COUNTY_CODE) t2
on t1.COUNTY_CODE=t2.COUNTY_CODE;
----
--select COUNTY_CODE,min(COUNTY_NAME),sum(case OPERATE_STATUS when '已开通' then 1 else 0 end ),count(*) from DW_LC_USER group by COUNTY_CODE