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