SELECT HOSPITALIZATION.PF_CODE AS 都道府県コード, PREFECTURE.PF_NAME AS 都道府県名, 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.0, 1) AS 入院率
    FROM HOSPITALIZATION
    LEFT JOIN PREFECTURE
    ON HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
    ORDER BY 入院率 DESC, 都道府県コード ASC