SELECT
    DRINK.PF_CODE AS CODE
    , PF_NAME AS NAME
    , ROUND (( CAST(DRINK.AMT AS REAL) / CAST(ALL_AMOUT.AMT AS REAL)) * 100, 1) AS PERCENTAGE
FROM
    (SELECT
        SUM(AMT) AS AMT
        , PF_CODE
    FROM
        DRINK_HABITS
    WHERE
        CATEGORY_CODE = '120'
        AND GENDER_CODE IN ('2', '3')
    GROUP BY
        PF_CODE
    ) AS DRINK
    INNER JOIN 
        (SELECT
            SUM(AMT) AS AMT
            , PF_CODE
        FROM
            DRINK_HABITS
        WHERE
            CATEGORY_CODE = '110'
            AND GENDER_CODE IN ('2', '3')
        GROUP BY
            PF_CODE
        ) AS ALL_AMOUT
        ON DRINK.PF_CODE = ALL_AMOUT.PF_CODE
    INNER JOIN PREFECTURE AS PF
        ON DRINK.PF_CODE = PF.PF_CODE

ORDER BY
    PERCENTAGE DESC
    , CODE