select 
 dh.PF_CODE as CODE
 , t1.PF_NAME as NAME
 , dh.AMT
 , round(cast(t1.AMT as real) / cast(sum(dh.AMT) as real) *100, 1) as PERCENTAGE
from DRINK_HABITS dh
join (
 select
  p.PF_CODE
  , p.PF_NAME
  , d.GENDER_CODE
  , d.CATEGORY_CODE
  , sum(d.AMT) as AMT
 from DRINK_HABITS d
 join PREFECTURE p on d.PF_CODE = p.PF_CODE
 where d.GENDER_CODE in (2, 3)
 and d.CATEGORY_CODE = 120
 group by p.PF_CODE
) t1 on t1.PF_CODE = dh.PF_CODE
where dh.CATEGORY_CODE = 110
group by CODE
order by PERCENTAGE desc;