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,
    HP.PF_CODE ASC
;