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