select
    t1.PF_CODE as 都道府県コード,
    t2.PF_NAME as 都道府県名,
    round((INP_YES/cast((INP_YES+INP_NO+UNIDENTIFIED) as REAL))*100,2) as 入院率
from
    HOSPITALIZATION as t1
    inner join PREFECTURE as t2 on(t1.PF_CODE=t2.PF_CODE)
order by
    round((INP_YES/cast((INP_YES+INP_NO+UNIDENTIFIED) as REAL))*100,2) desc,
    t1.PF_CODE