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