SELECT A.PF_CODE AS CODE,PF_NAME AS NAME,ROUND(1.0 * SUM(CASE WHEN CATEGORY_CODE=120 THEN AMT ELSE 0 END) / SUM(AMT) * 100,1) AS PERCENTAGE FROM PREFECTURE AS A,DRINK_HABITS AS B WHERE A.PF_CODE = B.PF_CODE AND GENDER_CODE IN (1,2) GROUP BY A.PF_CODE ORDER BY PERCENTAGE DESC,CODE DESC;