SELECT
    h.PF_CODE as "都道府県コード",
    p.PF_NAME as "都道府県名",
    ROUND((cast(INP_YES as real) / (INP_YES + INP_NO + UNIDENTIFIED)) * 100, 1) as "入院率"
FROM HOSPITALIZATION as h
INNER JOIN PREFECTURE as p
ON h.PF_CODE = p.PF_CODE
ORDER BY
    "入院率" DESC,
    "都道府県コード"
;