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