select
    d.PF_CODE as CODE
  , p.PF_NAME as NAME
  , round(
           sum(case when d.CATEGORY_CODE = '110' then d.AMT else 0 end)
         / sum(case when d.CATEGORY_CODE = '120' then d.AMT else 0 end)
      , 1
    ) as PERCENTAGE
from
           DRINK_HABITS d
inner join PREFECTURE   p
        on d.PF_CODE = p.PF_CODE
where
    d.GENDER_CODE in ('2', '3')
group by
    d.PF_CODE