请将下列5个select语句合并成为一个select语句SELECT PROV_DESC SUMCASE WHEN IS_INNET = 1 AND ADAY_ID = 23 AND AUSER_ID IS NOT NULL THEN 1 ELSE 0 ENDFROM SELECT USER_ID PROV_ID PRODUCT_ID DAY_ID IS

SELECT PROV_DESC, SUM(CASE WHEN IS_INNET = '1' AND A.DAY_ID = '23' AND A.USER_ID IS NOT NULL THEN 1 ELSE 0 END) AS sum1, COUNT(DISTINCT CASE WHEN SUBSTRING(a.open_date, 1, 8) <= '20230723' AND a.open_date >= '20230701' AND A.USER_ID IS NOT NULL THEN A.USER_ID END) AS count1, COUNT(DISTINCT CASE WHEN SUBSTRING(a.open_date, 1, 8) <= '20230623' AND a.open_date >= '20230601' AND A.USER_ID IS NOT NULL THEN A.USER_ID END) AS count2, COUNT(DISTINCT CASE WHEN SUBSTRING(a.open_date, 1, 6) = '202306' AND A.USER_ID IS NOT NULL THEN A.USER_ID END) AS count3, SUM(CASE WHEN a.IS_THIS_break = '1' AND A.USER_ID IS NOT NULL THEN 1 ELSE 0 END) AS sum2 FROM ( SELECT USER_ID, PROV_ID, PRODUCT_ID, DAY_ID, IS_INNET, IS_THIS_DEV, IS_THIS_break FROM zq_dwa.DWA_D_MRT_CB_USER_WORK_PHONE WHERE MONTH_ID = '202307' AND is_hd = '0' AND is_hyk = '0' AND is_yx = '1' ) A LEFT JOIN DIM_PROV b ON A.PROV_ID = B.PROV_ID LEFT JOIN ( SELECT open_date, USER_ID, PROV_ID, PRODUCT_ID, DAY_ID, month_id FROM zq_dwa.dwa_d_cus_al_cb_user_info WHERE MONTH_ID = '202307' AND DAY_ID = '23' ) c ON c.USER_ID = A.USER_ID LEFT JOIN ( SELECT USER_ID, PRODUCT_ID, DAY_ID, MONTH_ID, prov_id FROM zq_dwa.DWA_D_MRT_CB_USER_WORK_PHONE WHERE MONTH_ID = '202306' AND is_hd = '0' AND is_hyk = '0' AND is_yx = '1' and day_id = '23' ) d ON d.USER_ID = A.USER_ID LEFT JOIN ( SELECT open_date, USER_ID, PROV_ID, PRODUCT_ID, DAY_ID, month_id FROM zq_dwa.dwa_d_cus_al_cb_user_info WHERE MONTH_ID = '202306' AND DAY_ID = '23' ) e ON e.USER_ID = A.USER_ID GROUP BY PROV_DESC ORDER BY (CASE WHEN prov_desc='山东' THEN 1 WHEN prov_desc='河南' THEN 2 WHEN prov_desc='江苏' THEN 3 WHEN prov_desc='湖北' THEN 4 WHEN prov_desc='湖南' THEN 5 WHEN prov_desc='海南' THEN 6 WHEN prov_desc='重庆' THEN 7 WHEN prov_desc='四川' THEN 8 WHEN prov_desc='贵州' THEN 9 WHEN prov_desc='北京' THEN 10 WHEN prov_desc='山西' THEN 11 WHEN prov_desc='浙江' THEN 12 WHEN prov_desc='广东' THEN 13 WHEN prov_desc='西藏' THEN 14 WHEN prov_desc='甘肃