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