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