select
     main.PF_CODE as 都道府県コード
    ,pre.PF_NAME as 都道府県名
    ,round(main.INP_YES * 100.0 / (main.INP_YES + main.INP_NO + main.UNIDENTIFIED), 2) as 入院率
from
    HOSPITALIZATION as main
inner join
    PREFECTURE as pre using(PF_CODE)
order by
     入院率 desc
    ,都道府県コード asc