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