修改下列语句 要求输出顺序不变输出结果不包括prov_desc。：SELECT PROV_DESC COUNTDISTINCT CASE WHEN SUBSTRINGaopen_date 1 6 = 202306 AND AUSER_ID IS NOT NULL THEN AUSER_ID ENDFROM SELECT open_date USER_ID

SELECT COUNT(DISTINCT CASE WHEN SUBSTRING(a.open_date, 1, 6) = '202306' AND A.USER_ID IS NOT NULL THEN A.USER_ID END) FROM ( 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 = '30' ) a INNER 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_yx = '0' AND is_hd = '0' AND is_hyk = '0' AND day_id = '30' ) b ON b.USER_ID = a.USER_ID INNER 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 = '202307' AND is_yx = '1' AND is_hd = '0' AND is_hyk = '0' AND day_id = '23' ) c ON c.USER_ID = a.USER_ID LEFT JOIN DIM_PROV ON DIM_PROV.PROV_ID = a.PROV_ID GROUP BY DIM_PROV.PROV_DESC ORDER BY (CASE WHEN DIM_PROV.PROV_DESC='山东' THEN 1 WHEN DIM_PROV.PROV_DESC='河南' THEN 2 WHEN DIM_PROV.PROV_DESC='江苏' THEN 3 WHEN DIM_PROV.PROV_DESC='湖北' THEN 4 WHEN DIM_PROV.PROV_DESC='湖南' THEN 5 WHEN DIM_PROV.PROV_DESC='海南' THEN 6 WHEN DIM_PROV.PROV_DESC='重庆' THEN 7 WHEN DIM_PROV.PROV_DESC='四川' THEN 8 WHEN DIM_PROV.PROV_DESC='贵州' THEN 9 WHEN DIM_PROV.PROV_DESC='北京' THEN 10 WHEN DIM_PROV.PROV_DESC='山西' THEN 11 WHEN DIM_PROV.PROV_DESC='浙江' THEN 12 WHEN DIM_PROV.PROV_DESC='广东' THEN 13 WHEN DIM_PROV.PROV_DESC='西藏' THEN 14 WHEN DIM_PROV.PROV_DESC='甘肃' THEN 15 WHEN DIM_PROV.PROV_DESC='新疆' THEN 16 WHEN DIM_PROV.PROV_DESC='江西' THEN 17 WHEN DIM_PROV.PROV_DESC='云南' THEN 18 WHEN DIM_PROV.PROV_DESC='陕西' THEN 19 WHEN DIM_PROV.PROV_DESC='青海' THEN 20 WHEN DIM_PROV.PROV_DESC='宁夏' THEN 21 WHEN DIM_PROV.PROV_DESC='天津' THEN 22 WHEN DIM_PROV.PROV_DESC='内蒙古' THEN 23 WHEN DIM_PROV.PROV_DESC='上海' THEN 24 WHEN DIM_PROV.PROV_DESC='福建' THEN 25 WHEN DIM_PROV.PROV_DESC='广西' THEN 26 WHEN DIM_PROV.PROV_DESC='河北' THEN 27 WHEN DIM_PROV.PROV_DESC='辽宁' THEN 28 WHEN DIM_PROV.PROV_DESC='吉林' THEN 29 WHEN DIM_PROV.PROV_DESC='黑龙江' THEN 30 WHEN DIM_PROV.PROV_DESC='安徽' THEN 31 END)