SELECT
  DRINK_HABITS.PF_CODE AS CODE,
  PF_NAME AS NAME,
  ROUND(CAST(SUM(CASE WHEN CATEGORY_CODE = 120 THEN AMT ELSE 0 END) as REAL) * 100 / CAST(SUM(CASE WHEN CATEGORY_CODE = 110 THEN AMT ELSE 0 END) as REAL), 1) AS PERCENTAGE
FROM
  DRINK_HABITS
  LEFT JOIN PREFECTURE ON DRINK_HABITS.PF_CODE = PREFECTURE.PF_CODE
WHERE
  DRINK_HABITS.GENDER_CODE IN (2, 3)
GROUP BY
  DRINK_HABITS.PF_CODE
ORDER BY
  PERCENTAGE DESC,
  DRINK_HABITS.PF_CODE DESC