select
A.PF_CODE AS CODE,
B.PF_NAME AS NAME,
ROUND(CAST(SUM(A.AMT) AS REAL)/CAST(C.CA AS REAL)*100,1)AS PERCENTAGE

FROM DRINK_HABITS AS A
LEFT JOIN PREFECTURE AS B
ON A.PF_CODE = B.PF_CODE
LEFT JOIN (select
PF_CODE,
SUM(AMT) AS CA
FROM DRINK_HABITS 
WHERE 1=1 
AND (GENDER_CODE = '2' OR GENDER_CODE = '3')
GROUP BY PF_CODE) AS C
ON A.PF_CODE = C.PF_CODE

WHERE 1=1 
AND (GENDER_CODE = '2' OR GENDER_CODE = '3')
AND CATEGORY_CODE = '120'
GROUP BY B.PF_CODE
ORDER BY PERCENTAGE DESC,A.PF_CODE DESC
;