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