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