SELECT
    P.PF_CODE CODE,
    P.PF_NAME NAME,
    ROUND((DRINK.AMT*1.0/TOTAL.AMT)*100, 1) PERCENTAGE
FROM
    (SELECT SUM(AMT) AMT, PF_CODE 
    FROM DRINK_HABITS 
    WHERE CATEGORY_CODE = '110'
        AND GENDER_CODE IN ('2','3')
    GROUP BY PF_CODE
        ) TOTAL
    INNER JOIN
    (SELECT SUM(AMT) AMT, PF_CODE 
    FROM DRINK_HABITS 
    WHERE CATEGORY_CODE = '120'
        AND GENDER_CODE IN ('2','3')
    GROUP BY PF_CODE
        ) DRINK
    ON TOTAL.PF_CODE=DRINK.PF_CODE
    INNER JOIN PREFECTURE P ON TOTAL.PF_CODE = P.PF_CODE
ORDER BY
    PERCENTAGE DESC,
    CODE DESC