select
    pf_code as '都道府県コード',
    pf_name as '都道府県名',
    round((100.0 * INP_YES) / (INP_YES + INP_NO + UNIDENTIFIED + 0.0),1) as '入院率'
from
    hospitalization
    innner join prefecture using (pf_code)
order by pf_code asc;