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