select
h.PF_CODE '都道府県コード',
p.PF_NAME '都道府県名',
round(cast(INP_YES as real)/ (INP_YES+INP_NO+UNIDENTIFIED) * 100 , 2) '入院率'

from HOSPITALIZATION h

join PREFECTURE p
on h.PF_CODE = p.PF_CODE

order by
`入院率` desc