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