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