SELECT DISTINCT bprov_id COUNTDISTINCT adeveloper_idFROM zq_dwadwa_m_cus_al_cb_user_info aLEFT JOIN zq_dwdDWD_D_CUS_KK_NCUS_CMAN_INFO b ON anature_cust_id = bnature_cust_idWHERE aservice_kind = 05 AND

SELECT b.prov_id, COUNT(DISTINCT a.developer_id) FROM zq_dwa.dwa_m_cus_al_cb_user_info a LEFT JOIN zq_dwd.DWD_D_CUS_KK_NCUS_CMAN_INFO b ON a.nature_cust_id = b.nature_cust_id WHERE a.service_kind = '05' AND b.role = '1' AND a.month_id = 6 AND a.total_fee > 10000 GROUP BY b.prov_id;