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