select
    h.PF_CODE as `都道府県コード`,
    p.PF_NAME as `都道府県名`,
    round((cast(INP_YES as REAL) / cast(sum(INP_YES+INP_NO+UNIDENTIFIED) as REAL)) * 100,1) as `入院率`
from HOSPITALIZATION as h
left join PREFECTURE as p
on h.PF_CODE=p.PF_CODE
group by 1,2