SELECT
    dh.PF_CODE AS CODE,
    p.PF_NAME AS NAME,
    (
        ROUND(
            CAST(dh.DRINKS AS REAL) / CAST(dh.TOTAL AS REAL) * 100,
            1
        )
    ) AS PERCENTAGE
FROM
    (
        SELECT
            PF_CODE,
            SUM(
                CASE
                    WHEN CATEGORY_CODE = '110' THEN AMT
                    ELSE 0
                END
            ) AS TOTAL,
            SUM(
                CASE
                    WHEN CATEGORY_CODE = '120' THEN AMT
                    ELSE 0
                END
            ) AS DRINKS
        FROM
            DRINK_HABITS
        WHERE
            1 = 1
            AND GENDER_CODE IN ('2', '3')
        GROUP BY
            PF_CODE
    ) AS dh
    LEFT JOIN PREFECTURE p ON 1 = 1
    AND dh.PF_CODE = p.PF_CODE
ORDER BY
    PERCENTAGE DESC,
    CODE DESC