select
    pf.pf_code as "都道府県コード"
    ,pf.pf_name as "都道府県名"
    ,round(
        (cast(ho.inp_yes as real) / cast((ho.inp_yes+ho.inp_no+ho.unidentified) as real))*100
        ,1
    ) as "入院率"
from
    hospitalization as ho
    inner join prefecture as pf
        on ho.pf_code = pf.pf_code
order by
    "入院率" desc
    ,"都道府県コード" asc
;