SELECT
    d.PF_CODE AS CODE,
    PF_NAME AS NAME,
    ROUND(100 * CAST(SUM(CASE WHEN CATEGORY_CODE ="120" THEN AMT END) AS REAL) / CAST(SUM(AMT) AS REAL),2) AS PERCENTAGE
FROM DRINK_HABITS AS d
LEFT JOIN PREFECTURE AS p
ON d.PF_CODE = p.PF_CODE
WHERE
    GENDER_CODE IN ('2','3')
GROUP BY 1,2
ORDER BY 3 DESC,1 DESC