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, A.PF_CODE