SELECT
    pref.PF_CODE AS CODE
    , pref.PF_NAME AS NAME
    , ROUND(
        100.000 * SUM(CASE WHEN category_code = '120' THEN AMT ELSE NULL END) / SUM(CASE WHEN category_code = '110' THEN AMT ELSE NULL END)
    , 1) AS PERCENTAGE
FROM
    DRINK_HABITS AS dh
    INNER JOIN
        PREFECTURE AS pref
        ON dh.pf_code = pref.pf_code
WHERE
    gender_code IN ('2', '3')
GROUP BY
    1, 2
ORDER BY
    3 DESC, 1 DESC