select 
    a.pf_code as 都道府県コード,
    b.pf_name as 都道府県名,
    round(cast(a.inp_yes as real) * 100 / cast(a.inp_yes + a.inp_no + a.UNIDENTIFIED as real),1) as 入院率
from 
    HOSPITALIZATION a
inner join 
    PREFECTURE b
on
    a.pf_code=b.pf_code
    
order by 入院率 Desc, 都道府県コード asc;