SELECT
    DH.PF_CODE CODE
    ,PF.PF_NAME NAME
    ,ROUND(CAST(DAYL.AMT as REAL) / CAST(TOTL.AMT as REAL) * 100, 1) AS PERCENTAGE
    FROM
    DRINK_HABITS DH
            INNER JOIN (
                SELECT
                    MAX(PF_CODE) AS PF_CODE
                    ,SUM(AMT) AS AMT
                FROM
                    DRINK_HABITS
                WHERE
                    GENDER_CODE <> '1'
                    AND CATEGORY_CODE = '120' 
                GROUP BY
                PF_CODE
                ) DAYL
    ON DH.PF_CODE = DAYL.PF_CODE
            INNER JOIN (
                SELECT
                    MAX(PF_CODE)  AS PF_CODE
                    ,SUM(AMT) AS AMT
                FROM
                    DRINK_HABITS
                WHERE
                    GENDER_CODE <> '1'
                    AND CATEGORY_CODE = '110' 
                GROUP BY
                PF_CODE
                ) TOTL
    ON DH.PF_CODE = TOTL.PF_CODE
    LEFT JOIN PREFECTURE PF
    ON DH.PF_CODE = PF.PF_CODE
    WHERE
    1 = 1
    GROUP BY
    TOTL.PF_CODE
    ORDER BY 
    PERCENTAGE DESC ,  TOTL.PF_CODE DESC;