select 
    r.PF_CODE as "都道府県コード",
    PF_NAME as "都道府県名",
    ratio as "入院率"
from 
    (select
    pf_code,
    round((100*inp_yes/(inp_yes + INP_NO + UNIDENTIFIED)),1) as ratio
    from hospitalization) as r
    left join 
    PREFECTURE as p
    on r.PF_CODE = p.PF_CODE
order by 3 desc, 1 asc