select 
    HO.PF_CODE as 都道府県コード,
    PR.PF_NAME as 都道府県名,
    ROUND(
        CAST(HO.INP_YES as REAL)
        / (CAST(HO.INP_YES + HO.INP_NO + HO.UNIDENTIFIED as REAL)) * 100, 1) as 入院率 
from
    HOSPITALIZATION as HO
    inner join PREFECTURE  as PR
    on HO.PF_CODE = PR.PF_CODE
order by
    入院率 desc,
    HO.PF_CODE asc;