SELECT
A.PF_CODE AS CODE,
C.PF_NAME AS NAME,
round(cast(B.AMT AS REAL)/cast(A.AMT AS REAL)*100,1) 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,
(SELECT PF_CODE,AMT FROM DRINK_HABITS WHERE GENDER_CODE in('2','3') AND CATEGORY_CODE = 120 GROUP BY PF_CODE) B,
PREFECTURE C
where A.PF_CODE = B.PF_CODE
and A.PF_CODE = C.PF_CODE
order by 3 desc, 1 desc