SELECT
"都道府県コード",
"都道府県名",
(CASE WHEN "入院率" = CAST("入院率" AS INTEGER) THEN CAST("入院率" AS INTEGER) ELSE "入院率" END) AS "入院率"
FROM (
SELECT
h.PF_CODE AS "都道府県コード",
PF_NAME AS "都道府県名",
ROUND(INP_YES / CAST((INP_YES + INP_NO + UNIDENTIFIED) AS FLOAT) * 100, 1) AS "入院率"
FROM HOSPITALIZATION h
LEFT JOIN PREFECTURE p
ON h.PF_CODE = p.PF_CODE
) ORDER BY "入院率" DESC, "都道府県コード" ASC