select
    h.pf_code as 都道府県コード
    ,p.pf_name as 都道府県名
    ,round((cast(h.INP_YES as real) * 100) / cast((h.inp_Yes + h.inp_NO + h.unidentified) as real),1) as 入院率
from HOSPITALIZATION h
INNER JOIN PREFECTURE p
    ON h.pf_code = p.pf_code
ORDER BY
    入院率 DESC
    ,cast(都道府県コード as integer) ASC