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