select
    a.PF_CODE,
    b.PF_NAME,
    round((cast(INP_YES as real) / cast((INP_YES + INP_NO + UNIDENTIFIED) as real)) * 100, 2)
from
    HOSPITALIZATION as a
inner join
    PREFECTURE as b on a.PF_CODE = b.PF_CODE