SELECT
	PF_CODE as CODE
	, NAME
	, ROUND(CAST(inshu_num as REAL) / CAST(total_num as REAL), 1) 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)*100 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