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