SELECT
A.PF_CODE AS CODE,
C.PF_NAME AS NAME,
round(cast(ifnull(B.AMTIN,0) AS REAL)/cast(A.AMTALL AS REAL)*100,1) AS PERCENTAGE
FROM (SELECT PF_CODE,SUM(AMT) AS AMTALL FROM DRINK_HABITS WHERE GENDER_CODE in(2,3) AND CATEGORY_CODE = 110 GROUP BY PF_CODE) A
LEFT OUTER JOIN
(SELECT PF_CODE,SUM(AMT) AS AMTIN FROM DRINK_HABITS WHERE GENDER_CODE in(2,3) AND CATEGORY_CODE = 120 GROUP BY PF_CODE) B
ON A.PF_CODE = B.PF_CODE,
PREFECTURE C
where A.PF_CODE = C.PF_CODE
order by 3 desc, 1 desc