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