SELECT
	p.PF_CODE AS CODE
	,p.PF_NAME AS NAME
	,ROUND(
		100.0 * SUM(
			CASE d.CATEGORY_CODE 
				WHEN '120' THEN d.AMT
				ELSE 0
				END
		)/ SUM(
			CASE d.CATEGORY_CODE 
				WHEN '110' THEN d.AMT
				ELSE 0
				END
		)
	,2) AS PERCENTAGE
FROM
	DRINK_HABITS AS d
	INNER JOIN PREFECTURE AS p
		ON p.PF_CODE = d.PF_CODE
WHERE
	d.GENDER_CODE IN ('2', '3') 
GROUP BY
	d.PF_CODE
ORDER BY
	PERCENTAGE DESC
	,p.PF_CODE DESC;