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 DESC