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