SELECT A.PF_CODE AS CODE
	,B.PF_NAME AS NAME
	,ROUND(PERCENTAGE,2) AS PERCENTAGE
FROM (
SELECT C110.PF_CODE
,AMT_120/(AMT_110*1.0) * 100 AS PERCENTAGE
FROM (
	SELECT PF_CODE
	,SUM(AMT) AMT_110
	FROM DRINK_HABITS
	WHERE CATEGORY_CODE = 110
	AND GENDER_CODE IN (2,3)
	GROUP BY PF_CODE
) C110
,(
	SELECT PF_CODE
	,SUM(AMT) AMT_120
	FROM DRINK_HABITS
	WHERE CATEGORY_CODE = 120
	AND GENDER_CODE IN (2,3)
	GROUP BY PF_CODE
) C120
WHERE C110.PF_CODE = C120.PF_CODE
) A
	,PREFECTURE B
WHERE
 A.PF_CODE = B.PF_CODE
ORDER BY 3 DESC,1 DESC