select
    p.pf_code as "都道府県コード",
    PF_NAME as "都道府県名",
    round(100*cast(sum(INP_YES) as REAL) / cast(sum(INP_YES) + sum(INP_NO) + sum(UNIDENTIFIED) as REAL), 1) as "入院率"
from
    PREFECTURE as p LEFT OUTER JOIN HOSPITALIZATION as h   ON h.pf_code = p.pf_code
group by
    h.pf_code