select
  t1.PF_CODE as CODE
  , t2.PF_NAME as NAME
  , ROUND((CAST(SUM(CASE WHEN CATEGORY_CODE = 120 THEN AMT ELSE 0 END) as REAL) / CAST(sum(AMT) as REAL)) * 100, 1) as PERCENTAGE 
from
  DRINK_HABITS t1
  left join PREFECTURE t2
    on t1.PF_CODE = t2.PF_CODE
where
  GENDER_CODE in (2,3)
group by
  CODE
order by 
  PERCENTAGE desc, CODE