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