WITH
dh As (
SELECT 
    category_code,
    pf_code,
    SUM(amt) AS amt
FROM DRINK_HABITS
WHERE category_code != "130" and gender_code != '1'
GROUP BY 1,2
)
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.0,1) AS PERCENTAGE
FROM dh INNER JOIN prefecture USING(pf_code)
GROUP BY 1,2
ORDER BY 3 DESC, 1 DESC