SELECT *
FROM (
SELECT PREFECTURE.PF_CODE AS "都道府県コード" , PREFECTURE.PF_NAME AS "都道府県名", ROUND(IFNULL(CAST(INP_YES AS REAL) / (CAST(INP_YES AS REAL) + CAST(INP_NO AS REAL) + CAST(UNIDENTIFIED AS REAL)) * 100, 0), 1) AS "入院率"
FROM PREFECTURE
LEFT JOIN HOSPITALIZATION ON HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
GROUP BY PREFECTURE.PF_CODE, PREFECTURE.PF_NAME
)
ORDER BY "入院率" DESC, cast("都道府県コード" AS INTEGER) ASC