select
  a.PF_CODE as 'CODE',
  c.PF_NAME as 'NAME',
  round(a.BUNSI * 100.0 / b.BUNBO, 1) as PERCENTAGE
from
  (select
    PF_CODE,
    sum(AMT) as 'BUNSI'
    from DRINK_HABITS
    where CATEGORY_CODE = '120' and
          GENDER_CODE in('2', '3')
    group by PF_CODE) a,
  (select
    PF_CODE,
    sum(AMT) as 'BUNBO'
    from DRINK_HABITS
    where CATEGORY_CODE = '110'
    group by PF_CODE) b,
  PREFECTURE c
where
  a.PF_CODE = b.PF_CODE and
  a.PF_CODE = c.PF_CODE
order by 
  PERCENTAGE desc,
  CODE desc