SELECT
	SUM_AMT.PF_CODE AS CODE,
	P.PF_NAME  AS NAME,
	SUM_DRINK.D_AMT , SUM_AMT.AMT ,
	ROUND(CAST(SUM_DRINK.D_AMT AS REAL) / CAST(SUM_AMT.AMT AS REAL) * 100.0, 1) AS PERCENTAGE
FROM
	(SELECT PF_CODE, SUM(AMT) AS AMT  FROM DRINK_HABITS WHERE GENDER_CODE IN ('2', '3') AND CATEGORY_CODE = '110' GROUP BY PF_CODE) AS SUM_AMT
	LEFT JOIN 
	(SELECT PF_CODE, SUM(AMT) AS D_AMT FROM DRINK_HABITS WHERE GENDER_CODE IN ('2', '3') AND CATEGORY_CODE = '120' GROUP BY PF_CODE) AS SUM_DRINK
	ON SUM_AMT.PF_CODE = SUM_DRINK.PF_CODE
	LEFT JOIN PREFECTURE P
	ON SUM_AMT.PF_CODE = P.PF_CODE
ORDER BY
	PERCENTAGE DESC,
	CODE DESC