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