SELECT
 DH110.PF_CODE AS CODE
 , PR.PF_NAME AS NAME
 , ROUND(100* DH120.TOTAL_AMT / DH110.TOTAL_AMT, 2) AS PERCENTAGE
FROM 
 (SELECT PF_CODE, SUM(AMT) AS TOTAL_AMT FROM DRINK_HABITS WHERE CATEGORY_CODE = '110' AND GENDER_CODE IN ('2', '3') GROUP BY PF_CODE ) DH110
INNER JOIN
 (SELECT PF_CODE, SUM(AMT) AS TOTAL_AMT FROM DRINK_HABITS WHERE CATEGORY_CODE = '120' AND GENDER_CODE IN ('2', '3') GROUP BY PF_CODE ) DH120
ON DH120.PF_CODE = DH110.PF_CODE
INNER JOIN PREFECTURE PR
ON DH110.PF_CODE = PR.PF_CODE
ORDER BY PERCENTAGE DESC, DH110.PF_CODE DESC