WITH SUM_DH AS(
    SELECT
        PF_CODE,
        SUM(CASE
            WHEN CATEGORY_CODE = 120
                THEN AMT
            ELSE 0
            END) AS "SUM_120",
        SUM(CASE
            WHEN CATEGORY_CODE = 110
                THEN AMT
            ELSE 0
            END) AS "SUM_110"
    FROM
        DRINK_HABITS
    WHERE
        GENDER_CODE <> 1
    GROUP BY
        PF_CODE
)
SELECT
    t1.PF_CODE AS CODE,
    t2.PF_NAME AS NAME,
    ROUND(CAST(t1."SUM_120" AS REAL)/CAST(t1."SUM_110" AS REAL)*100,1) AS PERCENTAGE
FROM
    SUM_DH AS t1
INNER JOIN PREFECTURE t2
    ON t1.PF_CODE = t2.PF_CODE
ORDER BY
    PERCENTAGE DESC,
    CODE DESC
;