SELECT
    DH.PF_CODE AS CODE,
    P.PF_NAME AS NAME,
    ROUND(100.0 * SUM(CASE DH.CATEGORY_CODE WHEN '120' THEN CAST(DH.AMT AS DECIMAL(10,4)) ELSE 0 END) / SUM(CASE DH.CATEGORY_CODE WHEN '110' THEN CAST(DH.AMT AS DECIMAL(10,4)) 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
;