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