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