SELECT 
  a.PF_CODE as CODE,
  a.PF_NAME  as NAME, 
  round(cast(b.NONDERUHITO_AMT as REAL)/cast(c.SUM_AMT as REAL)*100,2) as PERCENTAGE
FROM
  PREFECTURE as a
INNER JOIN 
  (SELECT 
     PF_CODE,
     SUM(AMT) as NONDERUHITO_AMT
   FROM 
     DRINK_HABITS
   WHERE
     CATEGORY_CODE = '120' 
     AND GENDER_CODE in ('2','3')
   GROUP BY
     PF_CODE
   ) as b
INNER JOIN 
  (SELECT 
     PF_CODE,
     SUM(AMT) as SUM_AMT
   FROM 
     DRINK_HABITS
   WHERE
     GENDER_CODE in ('2','3')
   GROUP BY
     PF_CODE
   ) as c
ON
  a.PF_CODE = b.PF_CODE
  and a.PF_CODE = c.PF_CODE
ORDER BY
  PERCENTAGE DESC,
  CODE DESC