SELECT
    dh.PF_CODE AS CODE
    ,pr.PF_NAME AS NAME
    ,ROUND((100.0 * dh.AMT / sum_X.s_AMT),2) AS PERCENTAGE
FROM
    DRINK_HABITS dh
    INNER JOIN
        PREFECTURE pr
            ON dh.PF_CODE = pr.PF_CODE
                AND dh.GENDER_CODE IN ('2','3')
    CROSS JOIN
        (
            SELECT
                SUM(dh.AMT) AS s_AMT
            FROM
                DRINK_HABITS dh
            WHERE
                dh.GENDER_CODE IN ('2','3')
        ) sum_X
GROUP BY
    CODE
    ,NAME
ORDER BY
    PERCENTAGE DESC
    ,CODE DESC