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