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