SELECT
    d.PF_CODE as CODE,
    p.PF_NAME as NAME,
    SUM(CASE CATEGORY_CODE WHEN '120' THEN AMT ELSE NULL END) /SUM(CASE CATEGORY_CODE WHEN '110' THEN AMT ELSE NULL END) * 100  as PERCENTAGE
FROM
    DRINK_HABITS as d
JOIN
    PREFECTURE as p
ON
    d.PF_CODE == p.PF_CODE
WHERE
    d.GENDER_CODE != '1'
GROUP BY
    1, 2
ORDER BY
    3 DESC,
    1 DESC