SELECT
	PF_CODE
	, NAME
	,inshu_num, total_num
	, ROUND(((inshu_num*100) / total_num), 2) as PERCENTAGE
FROM
	(
		SELECT
			a.PF_CODE
			, b.PF_NAME as NAME
			, SUM(CASE WHEN a.CATEGORY_CODE = '120' AND a.GENDER_CODE IN(2,3) THEN AMT ELSE 0 END) as inshu_num
			, SUM(CASE WHEN a.CATEGORY_CODE = '110' AND a.GENDER_CODE IN(2,3) THEN AMT ELSE 0 END) as total_num
		FROM
			DRINK_HABITS as a
		INNER JOIN
			PREFECTURE as b
		ON
			a.PF_CODE = b.PF_CODE
		GROUP BY
			a.PF_CODE
			, NAME
	)
ORDER BY
	PERCENTAGE DESC
	, PF_CODE DESC