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