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