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