select 
A.PF_CODE as 都道府県コード,
P.PF_NAME as 都道府県名,
round(A.ratio, 1) as 入院率
from (
	select
		H.PF_CODE,
		100*cast(H.INP_YES as real)/cast((H.INP_YES+H.INP_NO+H.UNIDENTIFIED) as real) as ratio
	from 
		HOSPITALIZATION H
) A
inner join PREFECTURE P
on P.PF_CODE = A.PF_CODE
order by ratio DESC