修改SQL语句，去除PROV_DESC并按特定顺序排序

SELECT\n 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)\nFROM (\n SELECT\n open_date,\n USER_ID,\n PROV_ID,\n PRODUCT_ID,\n DAY_ID,\n\tmonth_id\n FROM zq_dwa.dwa_d_cus_al_cb_user_info\n WHERE\n MONTH_ID = '202306' AND DAY_ID = '23'\n) a\nINNER JOIN (\n SELECT\n USER_ID,\n PRODUCT_ID,\n DAY_ID,\n MONTH_ID,\n\tprov_id\n FROM zq_dwa.DWA_D_MRT_CB_USER_WORK_PHONE\n WHERE MONTH_ID = '202306' \n AND is_hd = '0'\n AND is_hyk = '0' \n AND is_yx = '1'\n\tand day_id = '23'\n) b ON b.USER_ID = a.USER_ID\nLEFT JOIN DIM_PROV ON DIM_PROV.PROV_ID = a.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\tEND);