cek DP4 PER KECselect (no_prop||(trim(to_char(no_kab,'00')))||(trim(to_char(no_kec,'00'))))kdkec,getnamakec(no_kec,no_kab,no_prop) nama_kec,(COUNT(DECODE(JENIS_KLMIN,1,1)))DAK_Lk,(COUNT(DECODE(JENIS_KLMIN,2,1)))DAK_PR,(count(*))DAKfrom biodata_DP4group by no_prop,no_kab,no_kecorder by no_kecHITUNG TOTAL UMUR 1-18 THN PER KELselect (no_prop||(trim(to_char(no_kab,'00')))||(trim(to_char(no_kec,'00'))))kdkec,getnamakec(no_kec,no_kab,no_prop) nama_kec,(no_prop||(trim(to_char(no_kab,'00')))||trim(to_char(no_kec,'00'))||no_kel)kdkel,getnamakel(no_kel,no_kec,no_kab,no_prop)Desa_kel,(COUNT(DECODE(JENIS_KLMIN,1,1)))LK,(COUNT(DECODE(JENIS_KLMIN,2,1)))PR,(count(*))TOTALFROM Biodata_wniWHERE ((FLOOR(MONTHS_BETWEEN('01 JUL 2015',TGL_LHR)/12)>=18))group by no_prop,no_kab,no_kec,no_kelorder by no_kec,no_kelHITUNG TOTAL UMUR 1-18 THN PER KEcselect (no_prop||(trim(to_char(no_kab,'00')))||(trim(to_char(no_kec,'00'))))kdkec,getnamakec(no_kec,no_kab,no_prop) nama_kec,(COUNT(DECODE(JENIS_KLMIN,1,1)))LK,(COUNT(DECODE(JENIS_KLMIN,2,1)))PR,(count(*))TOTALFROM Biodata_wniWHERE ((FLOOR(MONTHS_BETWEEN('01 JUL 2015',TGL_LHR)/12)>=18))group by no_prop,no_kab,no_kecorder by no_kecHITUNG TOTAL UMUR 1-18 THN MEMILIKI AKTA LAHIRselect (no_prop||(trim(to_char(no_kab,'00')))||(trim(to_char(no_kec,'00'))))kdkec,getnamakec(no_kec,no_kab,no_prop) nama_kec,(COUNT(DECODE(JENIS_KLMIN,1,1)))LK,(COUNT(DECODE(JENIS_KLMIN,2,1)))PR,(count(*))TOTALFROM Biodata_wniWHERE ((FLOOR(MONTHS_BETWEEN('01 JUL 2015',TGL_LHR)/12)>=18))and akta_lhr 1group by no_prop,no_kab,no_kecorder by no_kecHITUNG JUMLAH KELAHIRAN PER KECselect (adm_no_prov||(trim(to_char(adm_no_kab,'00')))||(trim(to_char(adm_no_kec,'00'))))kdkec,getnamakec(adm_no_kec,adm_no_kab,adm_no_prov) nama_kec,(COUNT(DECODE(BAYI_JNS_KELAMIN,1,1)))LK,(COUNT(DECODE(BAYI_JNS_KELAMIN,2,1)))PR,(count(*))TOTALfrom CAPIL_LAHIRgroup by adm_no_prov,adm_no_kab,adm_no_kecorder by adm_no_kecHITUNG JUMLAH KEMATIAN PER KECselect (adm_no_prov||(trim(to_char(adm_no_kab,'00')))||(trim(to_char(adm_no_kec,'00'))))kdkec,getnamakec(adm_no_kec,adm_no_kab,adm_no_prov) nama_kec,(COUNT(DECODE(MATI_JNS_KELAMIN,1,1)))LK,(COUNT(DECODE(MATI_JNS_KELAMIN,2,1)))PR,(count(*))TOTALfrom CAPIL_MATIgroup by adm_no_prov,adm_no_kab,adm_no_kecorder by adm_no_kecHITUNG BELUM REKAM PER KECselect TO_CHAR(NIK) nik, NO_KEL, NAMA_LGKP namafrom biodata_wniwhere (TGL_LHR 1 and TO_CHAR(NIK)not in(select to_char(NIK) from demographics) order by 2;HITUNG SUDAH REKAM PER KEC UNTUK SEMUA STATUS_CODE TERMASUK DUPLICATEselect (no_prop||(trim(to_char(no_kab,'00')))||(trim(to_char(no_kec,'00'))))kdkec,getnamakec(no_kec,no_kab,no_prop) nama_kec,(count(*))TOTALFROM DEMOGRAPHICSgroup by no_prop,no_kab,no_kecorder by no_kecHITUNG STATUS SUDAH REKAM PER KECselect (no_prop||(trim(to_char(no_kab,'00')))||(trim(to_char(no_kec,'00'))))kdkec,getnamakec(no_kec,no_kab,no_prop) nama_kec,(count(*))TOTALFROM DEMOGRAPHICSWHERE current_status_code= 'PRINT_READY_RECORD'group by no_prop,no_kab,no_kecorder by no_kec