select PERCENTAGETBL.PF_CODE as CODE, PRETBL.PF_NAME as NAME, PERCENTAGETBL.PERCENTAGE
FROM (select DRINKTBL.PF_CODE, round(cast(DRINKTBL.DRINK_AMT as real) / ALLTBL.ALL_AMT * 100, 1) as PERCENTAGE from 
(select PF_CODE, 
        SUM(AMT) as drink_amt 
   from DRINK_HABITS 
  where CATEGORY_CODE='120' 
    and GENDER_CODE in ('2', '3')
  group by PF_CODE
) DRINKTBL,
(select PF_CODE, 
        SUM(AMT) as all_amt 
   from DRINK_HABITS 
  where CATEGORY_CODE='110' 
    and GENDER_CODE in ('2', '3')
  group by PF_CODE
) ALLTBL
where DRINKTBL.PF_CODE=ALLTBL.PF_CODE
) PERCENTAGETBL,
PREFECTURE PRETBL
where PERCENTAGETBL.PF_CODE=PRETBL.PF_CODE
order by PERCENTAGE desc, CODE desc