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