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