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