SELECT 
PF_CODE AS CODE, 
MAX(PF_NAME) AS NAME,
round(SUM(CASE CATEGORY_CODE WHEN 120 THEN cast(AMT AS REAL) ELSE cast(0 AS REAL) END) /
SUM(CASE CATEGORY_CODE WHEN 110 THEN cast(AMT AS REAL) ELSE cast(0 AS REAL) END) * 100, 1) AS PERCENTAGE
FROM DRINK_HABITS AS d JOIN PREFECTURE AS p USING(PF_CODE) 
WHERE GENDER_CODE IN ("2", "3")
GROUP BY PF_CODE
ORDER BY PERCENTAGE DESC, CODE