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