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