SELECT
A.PF_CODE AS CODE,
C.PF_NAME AS NAME,
round(cast(ifnull(B.AMT,0) AS REAL)/cast(A.AMT AS REAL)*100,2) AS PERCENTAGE
FROM (SELECT PF_CODE,AMT FROM DRINK_HABITS WHERE GENDER_CODE in('2','3') AND CATEGORY_CODE = 110 GROUP BY PF_CODE) A
LEFT OUTER JOIN
(SELECT PF_CODE,AMT 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