SELECT  T.PF_CODE AS '都道府県コード'
       ,P.PF_NAME AS '都道府県名'
       ,FORMAT('%g', 
          ROUND(CAST(INP_YES AS REAL) * 100 / 
                CAST(INP_YES + INP_NO + UNIDENTIFIED AS REAL)
                , 1)
        )         AS '入院率'
  FROM HOSPITALIZATION AS T
  LEFT OUTER JOIN PREFECTURE AS P
    ON T.PF_CODE = P.PF_CODE --都道府県コード
 ORDER BY  入院率 DESC
          ,T.PF_CODE