select
    t1.PF_CODE as 都道府県コード,
    t2.PF_NAME as 都道府県名,
    round(INP_YES/cast(INP_YES+INP_NO+UNIDENTIFIED as REAL)*100 ,1) as 入院率

from
    HOSPITALIZATION as t1
    inner join PREFECTURE as t2 on (t1.PF_CODE=t2.PF_CODE)
order by
    入院率 desc,
    t1.PF_CODE