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') as REAL)
 / cast((SELECT SUM(AMT) FROM DRINK_HABITS AS D WHERE A.PF_CODE = D.PF_CODE AND CATEGORY_CODE = '110') 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