修改下列语句 要求输出顺序不变输出结果不包括prov_desc。SELECT PROV_DESC SUMCASE WHEN aIS_THIS_break = 1 AND AUSER_ID IS NOT NULL THEN 1 ELSE 0 ENDFROM SELECT USER_ID PROV_ID PRODUCT_ID DAY_ID IS_INNET

要求输出顺序不变，输出结果不包括prov_desc。修改后的语句如下：

SELECT SUM(CASE WHEN a.IS_THIS_break = '1' AND A.USER_ID IS NOT NULL THEN 1 ELSE 0 END) 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 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='甘肃' THEN 15 WHEN prov_desc='新疆' THEN 16 WHEN prov_desc='江西' THEN 17 WHEN prov_desc='云南' THEN 18 WHEN prov_desc='陕西' THEN 19 WHEN prov_desc='青海' THEN 20 WHEN prov_desc='宁夏' THEN 21 WHEN prov_desc='天津' THEN 22 WHEN prov_desc='内蒙古' THEN 23 WHEN prov_desc='上海' THEN 24 WHEN prov_desc='福建' THEN 25 WHEN prov_desc='广西' THEN 26 WHEN prov_desc='河北' THEN 27 WHEN prov_desc='辽宁' THEN 28 WHEN prov_desc='吉林' THEN 29 WHEN prov_desc='黑龙江' THEN 30 WHEN prov_desc='安徽' THEN 31 END)