SQL 语句优化：去除 PROV_DESC 并按省份排序

要求输出顺序不变，输出结果不包括prov_desc。修改后的语句如下：\n\nSELECT \n SUM(CASE WHEN a.IS_THIS_break = '1' AND A.USER_ID IS NOT NULL THEN 1 ELSE 0 END)\nFROM (\n SELECT \n USER_ID,\n PROV_ID,\n PRODUCT_ID,\n DAY_ID,\n IS_INNET,\n IS_THIS_DEV,\n IS_THIS_break\n FROM zq_dwa.DWA_D_MRT_CB_USER_WORK_PHONE\n WHERE \n MONTH_ID = '202307'\n AND is_hd = '0'\n AND is_hyk = '0' \n AND is_yx = '1'\n) A\nLEFT JOIN DIM_PROV b ON A.PROV_ID = B.PROV_ID\nGROUP BY PROV_DESC\nORDER BY (CASE\n WHEN prov_desc='山东' THEN 1\n WHEN prov_desc='河南' THEN 2\n WHEN prov_desc='江苏' THEN 3\n WHEN prov_desc='湖北' THEN 4\n WHEN prov_desc='湖南' THEN 5\n WHEN prov_desc='海南' THEN 6\n WHEN prov_desc='重庆' THEN 7\n WHEN prov_desc='四川' THEN 8\n WHEN prov_desc='贵州' THEN 9\n WHEN prov_desc='北京' THEN 10\n WHEN prov_desc='山西' THEN 11\n WHEN prov_desc='浙江' THEN 12\n WHEN prov_desc='广东' THEN 13\n WHEN prov_desc='西藏' THEN 14\n WHEN prov_desc='甘肃' THEN 15\n WHEN prov_desc='新疆' THEN 16\n WHEN prov_desc='江西' THEN 17\n WHEN prov_desc='云南' THEN 18\n WHEN prov_desc='陕西' THEN 19\n WHEN prov_desc='青海' THEN 20\n WHEN prov_desc='宁夏' THEN 21\n WHEN prov_desc='天津' THEN 22\n WHEN prov_desc='内蒙古' THEN 23\n WHEN prov_desc='上海' THEN 24\n WHEN prov_desc='福建' THEN 25\n WHEN prov_desc='广西' THEN 26\n WHEN prov_desc='河北' THEN 27\n WHEN prov_desc='辽宁' THEN 28\n WHEN prov_desc='吉林' THEN 29\n WHEN prov_desc='黑龙江' THEN 30\n WHEN prov_desc='安徽' THEN 31\n END);