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