SELECT P.PF_CODE AS CODE, P.PF_NAME AS NAME,
ROUND(CAST(SUM(CASE WHEN DH.CATEGORY_CODE = "120" AND DH.GENDER_CODE IN ("2", "3") THEN DH.AMT ELSE 0 END) AS REAL)
/ CAST(SUM(CASE WHEN DH.CATEGORY_CODE = "110" AND DH.GENDER_CODE IN ("2", "3") THEN DH.AMT ELSE 0 END) AS REAL) * 100, 1) AS PERCENTAGE
FROM DRINK_HABITS AS DH JOIN PREFECTURE AS P USING(PF_CODE)
WHERE DH.GENDER_CODE IN ("2", "3")
GROUP BY P.PF_CODE
ORDER BY PERCENTAGE DESC, P.PF_CODE DESC;