SELECT D.PF_CODE AS CODE,
       P.PF_NAME AS NAME,
       ROUND(CAST(SUM(D2.AMT) AS REAL) / CAST(SUM(D.AMT) AS REAL)*100, 1) AS PERCENTAGE
  FROM DRINK_HABITS D
  LEFT JOIN PREFECTURE P 
    ON D.PF_CODE = P.PF_CODE
  LEFT JOIN DRINK_HABITS D2
    ON D.PF_CODE = D2.PF_CODE
   AND D2.CATEGORY_CODE = 120
   AND D2.GENDER_CODE <> '1'
 WHERE D.GENDER_CODE <> '1'
   AND D.CATEGORY_CODE = 110
 GROUP BY CODE 
 ORDER BY PERCENTAGE DESC,
          D.PF_CODE DESC