select
    HOSPITALIZATION.PF_CODE as 都道府県コード,
    PREFECTURE.PF_NAME as 都道府県名,
    round(
        (
            cast(HOSPITALIZATION.INP_YES as real) / (
                HOSPITALIZATION.INP_YES + HOSPITALIZATION.INP_NO + HOSPITALIZATION.UNIDENTIFIED
            )
        ) * 100,
        1
    ) as 入院率
from
    HOSPITALIZATION
    join PREFECTURE on HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
order by
    入院率 desc,
    都道府県コード;