SELECT
    P.PF_CODE as CODE,
    P.PF_NAME as NAME,
    round(100.0 * SUM(
        CASE
            WHEN D.CATEGORY_CODE = '120'
            and D.GENDER_CODE in ('2', '3') THEN AMT
        END
    ) / SUM(
        CASE
            WHEN D.CATEGORY_CODE = '110'
            and D.GENDER_CODE in ('2', '3') THEN AMT
        END
    ), 1) as PERCENTAGE
FROM
    PREFECTURE as P
    INNER JOIN DRINK_HABITS as D on P.PF_CODE = D.PF_CODE
GROUP BY
    P.PF_CODE
ORDER BY
    PERCENTAGE DESC,
    P.PF_CODE DESC