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