select 
    h.pf_code as "都道府県コード",
    p.pf_name as "都道府県名",
    round(inp_yes * 100.0 / (inp_yes + inp_no + unidentified), 1) as "入院率"
from 
    hospitalization h 
left join 
    prefecture p 
    on h.pf_code = p.pf_code 
order by 
    "入院率" desc,
    "都道府県コード" asc