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