SELECT
    HSP.PF_CODE AS '都道府県コード'
    ,PF.PF_NAME AS '都道府県名'
    ,ROUND(
        CAST(HSP.INP_YES AS FLOAT)*100
        /
        (CAST(HSP.INP_YES AS FLOAT)  + CAST(HSP.INP_NO AS FLOAT) + CAST(HSP.UNIDENTIFIED AS FLOAT))
        ,1)
     AS '入院率'
FROM
    HOSPITALIZATION AS HSP

    INNER JOIN
        PREFECTURE AS PF
    ON
        HSP.PF_CODE = PF.PF_CODE
ORDER BY
    入院率 DESC
    ,HSP.PF_CODE