将以下语句改成附和hive sql 的语句：select uuser_id unatural_cust_id uprov_idfrom zq_dwadwa_m_cus_al_cb_user_info uinner join select anatural_cust_id bcust_levelfrom zq_dwadwa_m_cus_al_cb_user_

SELECT u.user_id, u.natural_cust_id, u.prov_id FROM zq_dwa.dwa_m_cus_al_cb_user_info u INNER JOIN (SELECT a.natural_cust_id, b.cust_level FROM zq_dwa.dwa_m_cus_al_cb_user_info a LEFT JOIN zq_dwa.dwa_m_cus_al_list_nat_info b ON a.natural_cust_id = b.nature_id WHERE b.cust_level = '0'

UNION ALL

SELECT a.prov_id, a.natural_cust_id, b.cust_level FROM zq_dwa.dwa_m_cus_al_cb_user_info a LEFT JOIN zq_dwa.dwa_m_cus_al_list_nat_info b ON a.prov_id = b.prov_id AND a.natural_cust_id = b.nature_id WHERE b.cust_level = '1') t ON u.user_id = t.user_id AND u.natural_cust_id = t.natural_cust_id AND u.prov_id = t.prov_id GROUP BY u.natural_cust_id ORDER BY u.total_fee LIMIT 50