WITH AMT AS(
SELECT
    PF_CODE AS CODE
    , CATEGORY_CODE
    , sum(AMT)
    -- , 都道府県毎の毎日飲酒率 AS PERCENTAGE
FROM DRINK_HABITS
WHERE GENDER_CODE IN ('2', '3')
    AND CATEGORY_CODE IN ('110', '120')
GROUP BY CATEGORY_CODE, PF_CODE
)

SELECT * 
FROM AMT LEFT OUTER JOIN PREFECTURE P
    ON AMT.CODE = P.PF_CODE
GROUP BY AMT.CODE, P.PF_NAME