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 HP
	inner join PREFECTURE PF
	on PF.PF_CODE = HP.PF_CODE
order by
	入院率 desc
	,PF.PF_CODE asc;