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