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