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