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