select
    d.PF_CODE as CODE
  , p.PF_NAME as NAME
  , round(
         (   cast(sum(case when d.CATEGORY_CODE = '120' then d.AMT else 0 end) as real)
           / cast(sum(case when d.CATEGORY_CODE = '110' then d.AMT else 0 end) as real)
         ) * 100
      , 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
order by
    PERCENTAGE desc
  , CODE       desc
;