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