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