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