SELECT 
TOTAL.PF_CODE AS CODE,
MAX(P.PF_NAME) AS NAME,
ROUND(100*CAST(SUM(EVERYDAY.AMT) AS REAL)/CAST(SUM(TOTAL.AMT) AS REAL),1) AS PERCENTAGE
FROM(
   SELECT PF_CODE,AMT,GENDER_CODE
   FROM DRINK_HABITS
   WHERE CATEGORY_CODE = 110
   AND (GENDER_CODE = 2 OR GENDER_CODE = 3)
)TOTAL
INNER JOIN 
(
    SELECT PF_CODE,AMT,GENDER_CODE
    FROM DRINK_HABITS
    WHERE CATEGORY_CODE = 120
    AND (GENDER_CODE = 2 OR GENDER_CODE = 3)
)EVERYDAY
ON TOTAL.PF_CODE = EVERYDAY.PF_CODE AND TOTAL.GENDER_CODE = EVERYDAY.GENDER_CODE
INNER JOIN PREFECTURE P
ON TOTAL.PF_CODE = P.PF_CODE
GROUP BY TOTAL.PF_CODE
ORDER BY
PERCENTAGE DESC, 
TOTAL.PF_CODE DESC