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