SELECT hos.PF_CODE AS "都道府県コード",
       pf.PF_NAME AS "都道府県名",
       ROUND(((hos.INP_YES / (CAST(hos.INP_YES AS REAL) + CAST(hos.INP_NO AS REAL) + CAST(hos.UNIDENTIFIED AS REAL))) * 100), 1) AS "入院率"
         FROM HOSPITALIZATION AS hos
           INNER JOIN PREFECTURE AS pf
             ON (hos.PF_CODE == pf.PF_CODE)
             ORDER BY "入院率" DESC, "都道府県コード" ASC