SELECT PR.PF_CODE AS CODE
,PR.PF_NAME AS NAME
,ROUND(CAST(EV.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 (SELECT SUM(AMT) AS AMT
                  ,PF_CODE AS PF_CODE
              FROM DRINK_HABITS
              WHERE CATEGORY_CODE = '120'
              AND GENDER_CODE <>'1'
              GROUP BY PF_CODE) AS EV
        ON EV.PF_CODE=DH.PF_CODE

WHERE CATEGORY_CODE = '110'
              AND GENDER_CODE <>'1'
GROUP BY PR.PF_CODE,PR.PF_NAME
ORDER BY PERCENTAGE desc,
CODE desc