SELECT
    d.PF_CODE as CODE,
    p.PF_NAME as NAME, 
    ROUND(CAST( SUM(CASE CATEGORY_CODE WHEN '120' THEN AMT ELSE 0 END) as REAL ) / CAST( SUM(CASE CATEGORY_CODE WHEN '110' THEN AMT ELSE 0 END) AS REAL) * 100, 1) 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