SELECT
    HP.PF_CODE AS '都道府県コード',
    PF.PF_NAME AS '都道府県名',
    ROUND(cast(INP_YES AS REAL) / cast(INP_YES + INP_NO + 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,
    '都道府県コード' ASC
;