select
    DH1.PF_CODE AS CODE
    ,PF.PF_NAME AS NAME
    ,ROUND(
            CAST(SUBAMT AS REAL) /
            CAST(SUM(DH1.AMT) as REAL) * 100
            , 1) AS PERCENTAGE
FROM DRINK_HABITS DH1
LEFT JOIN (
            select SUM(AMT) AS SUBAMT, PF_CODE
            FROM DRINK_HABITS 
            WHERE CATEGORY_CODE = '120'
                AND GENDER_CODE <> '0'
            GROUP BY PF_CODE
            ) AS SUB
    ON DH1.PF_CODE = SUB.PF_CODE
INNER JOIN PREFECTURE PF
    ON DH1.PF_CODE = PF.PF_CODE
WHERE DH1.GENDER_CODE <> '0'
GROUP BY DH1.PF_CODE
ORDER BY 
    PERCENTAGE DESC
    ,DH1.PF_CODE DESC
;