select
    HP.PF_CODE as "都道府県コード"
    ,PR.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
    inner join 
        PREFECTURE as PR
        on HP.PF_CODE = PR.PF_CODE


order by
    入院率 desc,
    都道府県コード asc
;