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

INNER JOIN
    PREFECTURE
ON  DH_ALL.PF_CODE  = PREFECTURE.PF_CODE
ORDER BY
    PERCENTAGE DESC
,   CODE DESC