现在需要写出对应下面要求的hive sql 语句。已知表zq_dwadwa_m_cus_al_cb_user_info中有字段prov_idmonth_idservice_kindnature_cust_idtotal_fee；表zq_dwdDWD_D_CUS_KK_NCUS_CMAN_INFO中有字段developer_idnature_cust_idroleprov_idmonth_id。现要

以下是对应的Hive SQL语句：

SELECT DISTINCT b.prov_id, COUNT(DISTINCT a.developer_id) as developer_count
FROM zq_dwa.dwa_m_cus_al_cb_user_info a
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;

该查询语句首先从表zq_dwa.dwa_m_cus_al_cb_user_info中选择service_kind为'05'的记录，然后根据nature_cust_id关联表zq_dwd.DWD_D_CUS_KK_NCUS_CMAN_INFO，筛选出role为'1'并且month_id为6的记录。最后统计满足条件的记录中total_fee大于1万的developer_id数量，并按照prov_id进行去重和分组