SELECT
    DH1.PF_CODE AS CODE
    ,PF.PF_NAME AS NAME
    ,ROUND(100.0 * SUM(DH1.AMT) / SUM(DH2.AMT), 1) AS PERCENTAGE
FROM
    DRINK_HABITS AS DH1
        INNER JOIN DRINK_HABITS AS DH2
            ON DH1.PF_CODE = DH2.PF_CODE
            AND DH2.CATEGORY_CODE = 110
            AND DH2.GENDER_CODE IN (2, 3)
        INNER JOIN PREFECTURE AS PF
            ON DH1.PF_CODE = PF.PF_CODE
WHERE
    DH1.CATEGORY_CODE = 120
    AND DH1.GENDER_CODE IN (2, 3)
GROUP BY
    DH1.PF_CODE
ORDER BY
    PERCENTAGE DESC
    ,CODE DESC