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