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