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