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