SELECT
H.PF_CODE AS "都道府県コード",
P.PF_NAME AS "都道府県名",
CASE
WHEN ROUND(CAST(H.INP_YES AS REAL) * 100 / (CAST(H.INP_YES AS REAL) + CAST(H.INP_NO AS REAL) + CAST(H.UNIDENTIFIED AS REAL)), 1) LIKE '%.0'
THEN ROUND(CAST(H.INP_YES AS REAL) * 100 / (CAST(H.INP_YES AS REAL) + CAST(H.INP_NO AS REAL) + CAST(H.UNIDENTIFIED AS REAL)))
ELSE ROUND(CAST(H.INP_YES AS REAL) * 100 / (CAST(H.INP_YES AS REAL) + CAST(H.INP_NO AS REAL) + CAST(H.UNIDENTIFIED AS REAL)), 1)
END AS "入院率"
FROM HOSPITALIZATION H
INNER JOIN PREFECTURE P
ON P.PF_CODE = H.PF_CODE
GROUP BY H.PF_CODE
ORDER BY "入院率" DESC, "都道府県コード" ASC;