select 
	HP.PF_CODE as 都道府県コード,
	 PF.PF_NAME as 都道府県名, 
	 ROUND
	 (
	 CAST(HP.INP_YES AS REAL)/
	 CAST((HP.INP_YES + HP.INP_NO + HP.UNIDENTIFIED) AS REAL) *100,1
	 ) 
	 as 入院率
from HOSPITALIZATION as HP
	inner join PREFECTURE as PF
	on HP.PF_CODE = PF.PF_CODE
order by 入院率 desc,
		 都道府県コード asc;