select
	h.pf_code as '都道府県コード'
	,p.pf_name as '都道府県名'
	,round(cast(h.inp_yes as real) / cast(h.inp_yes + h.inp_no + h.unidentified as real) * 100, 1) as '入院率'
from
	hospitalization h
join
	prefecture p
on
    h.pf_code = p.pf_code
order by
	3 desc, 1