SELECT DRNK1.PF_CODE CODE, PREF.PF_NAME NAME,
    ROUND(CAST(DRNK2.SAKENOMI AS REAL) / CAST(SUM(DRNK1.AMT) AS READ) * 100,1) PERCENTAGE
FROM DRINK_HABITS DRNK1
    LEFT JOIN
        (
            SELECT PF_CODE, SUM(AMT) SAKENOMI
            FROM DRINK_HABITS
            WHERE CATEGORY_CODE = '120'
                AND GENDER_CODE IN ('2','3')
            GROUP BY PF_CODE
        ) DRNK2
        ON DRNK1.PF_CODE = DRNK2.PF_CODE
    LEFT JOIN PREFECTURE PREF
        ON DRNK1.PF_CODE = PREF.PF_CODE
WHERE DRNK1.CATEGORY_CODE = '110'
GROUP BY DRNK1.PF_CODE, DRNK2.SAKENOMI
ORDER BY PERCENTAGE DESC, DRNK1.PF_CODE DESC