SELECT 
  A.PF_CODE  AS CODE,
  PF_NAME   AS NAME,
(


round(100 * cast((SELECT SUM(AMT) FROM DRINK_HABITS AS C WHERE A.PF_CODE = C.PF_CODE AND CATEGORY_CODE = '120' GROUP BY C.PF_CODE) as REAL)
 / cast((SELECT SUM(AMT) FROM DRINK_HABITS AS D WHERE A.PF_CODE = D.PF_CODE AND CATEGORY_CODE = '110'GROUP BY D.PF_CODE) as REAL),
 
 1)
 ) AS PERCENTAGE
FROM 
  DRINK_HABITS AS A
INNER JOIN PREFECTURE AS B ON A.PF_CODE =  B.PF_CODE  
WHERE 
  GENDER_CODE IN ('2', '3') AND CATEGORY_CODE != '130'
GROUP BY A.PF_CODE
ORDER BY PERCENTAGE DESC, A.PF_CODE ASC