with
  a as (
    select
      PF_CODE,
      sum(
        case CATEGORY_CODE
          when '120' then amt
          else 0
        end
      ) v1,
      sum(
        case CATEGORY_CODE
          when '110' then amt
          else 0
        end
      ) v2
    from
      DRINK_HABITS
    where
      GENDER_CODE in ('2', '3')
    group by
      PF_CODE
  )
select
  a.pf_code CODE,
  pre.pf_name NAME,
  round(
    cast(ifnull(v1, 0) as REAL) * 100.0 / cast(ifnull(v2, 0) as real),
    1
  ) as PERCENTAGE
from
  a
  join PREFECTURE pre on pre.PF_CODE = a.PF_CODE
order by
  3 desc,
  1 desc;