SQL 查询：统计特定条件下开发者的省份分布

SELECT b.prov_id, COUNT(DISTINCT a.developer_id)\nFROM zq_dwa.dwa_m_cus_al_cb_user_info a\nLEFT JOIN zq_dwd.DWD_D_CUS_KK_NCUS_CMAN_INFO b ON a.nature_cust_id = b.nature_cust_id\nWHERE a.service_kind = '05' AND b.role = '1' AND a.month_id = 6 AND a.total_fee > 10000\nGROUP BY b.prov_id;