SELECT tab.PF_CODE AS "都道府県コード"
     , tab.PF_NAME AS "都道府県名"
     , ROUND(tab.INP_RATE*100, 1) AS "入院率"
  FROM (
       SELECT inp.PF_CODE
            , pf.PF_NAME
            , inp.INP_YES
            , inp.INP_NO
            , inp.UNIDENTIFIED
            , CAST(inp.INP_YES AS REAL)/(inp.INP_YES+inp.INP_NO+inp.UNIDENTIFIED) AS INP_RATE
         FROM HOSPITALIZATION AS inp
              LEFT OUTER JOIN PREFECTURE AS pf
                           ON pf.PF_CODE = inp.PF_CODE
       ) tab
 ORDER BY tab.INP_RATE desc
        , tab.PF_CODE asc
;