SELECT 
DRINK_HABITS.PF_CODE AS CODE,
PF_NAME AS NAME,
ROUND((100.0 * SUM(CASE WHEN DRINK_HABITS.CATEGORY_CODE = 120 THEN DRINK_HABITS.AMT ELSE 0 END) / SUM(CASE WHEN DRINK_HABITS.CATEGORY_CODE = 110 THEN DRINK_HABITS.AMT ELSE 0 END)),1) 
AS PERCENTAGE
FROM 
DRINK_HABITS
INNER JOIN PREFECTURE ON
DRINK_HABITS.PF_CODE = PREFECTURE.PF_CODE
GROUP BY PF_NAME

ORDER BY PERCENTAGE DESC, CODE DESC
;