select
h.PF_CODE '都道府県コード',
p.PF_NAME '都道府県名',
round(cast(INP_YES as real)/ (INP_YES+INP_NO+UNIDENTIFIED) * 100 , 1) '入院率'
from HOSPITALIZATION h
join PREFECTURE p
on h.PF_CODE = p.PF_CODE
order by
`入院率` desc,
`都道府県コード`