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