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