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