select
    t1.PF_CODE as 都道府県コード,
    t2.PF_NAME as 都道府県名,
    ROUND(CAST(t1.INP_YES AS FLOAT) / (INP_YES + INP_NO + UNIDENTIFIED) * 100, 1) as 入院率
from
    HOSPITALIZATION t1
inner join
    PREFECTURE t2
    on  t1.PF_CODE = t2.PF_CODE
order by 3 desc, 1
;