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