with pre1 as (
select
    pf_code
    , round(cast(inp_yes as real) / (cast(inp_yes as real) + cast(inp_no as real) + cast(unidentified as real)) * 100, 1) as wariai
from 
    hospitalization
)
select
    a.pf_code as '都道府県コード'
    , b.pf_name as '都道府県名'
    , a.wariai as '入院率'
from
    pre1 as a
left join 
    prefecture as b
on
    a.pf_code = b.pf_code
order by 
    a.wariai desc
    , a.pf_code asc