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