select
    T1.PF_CODE AS "都道府県コード"
   ,T2.PF_NAME AS "都道府県名"
   ,ROUND(
        CAST(T1.INP_YES as real) / 
        (
            CAST(T1.INP_YES as real) + 
            CAST(T1.INP_NO as real)  + 
            CAST(T1.UNIDENTIFIED as real)
        ) * 100
    ,1) AS "入院率"
from
    HOSPITALIZATION T1
left join
    PREFECTURE      T2
on  T2.PF_CODE = T1.PF_CODE
order by
    "入院率" desc
   ,"都道府県コード"