select
  dh.PF_CODE as CODE
  ,pf.PF_NAME as NAME
  ,round(100 * cast(sum(case when category_code = '120' and gender_code in ('2','3') then amt else 0 end) as real)/cast(sum(amt) as real), 1) as PERCENTAGE
from drink_habits dh
join prefecture pf
  on dh.pf_code = pf.pf_code
group by 1,2
order by percentage desc, code
;