select
    p.PF_CODE as '都道府県コード',
    p.PF_NAME as '都道府県名',
    ROUND(h.INP_YES * 100.0 / (h.INP_YES + h.INP_NO + h.UNIDENTIFIED), 1) as '入院率'
from
    PREFECTURE as p
    join HOSPITALIZATION as h
    on p.PF_CODE = h.PF_CODE
order by
    入院率 desc,
    p.PF_CODE asc
;