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