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