SELECT PR.PF_CODE AS CODE
,PR.PF_NAME AS NAME
,ROUND(SUM(CAST(EVERY.AMT AS REAL))/SUM(CAST(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 EVERY
ON EVERY.PF_CODE =DH.PF_CODE 
AND EVERY.CATEGORY_CODE='120'
AND EVERY.GENDER_CODE<>'1'
WHERE 1=1
AND DH.GENDER_CODE<>'1'
AND DH.CATEGORY_CODE='110'
GROUP BY PR.PF_CODE
,PR.PF_NAME
ORDER BY PERCENTAGE desc
,CODE desc;