SELECT
	  a.PF_CODE "CODE"
	, b.PF_NAME "NAME"
	, round( 
		CAST( 
			SUM( 
				CASE 
					WHEN a.GENDER_CODE IN ('2', '3') 
					AND a.CATEGORY_CODE = '120' 
						THEN a.AMT 
					ELSE NULL 
					END
			) AS REAL
		) / CAST( 
			SUM( 
				CASE 
					WHEN a.GENDER_CODE IN ('2', '3') 
					AND a.CATEGORY_CODE = '110' 
						THEN a.AMT 
					ELSE NULL 
					END
			) AS REAL
		) * 100
		, 2
	) "PERCENTAGE" 
FROM
	DRINK_HABITS a 
	INNER JOIN PREFECTURE b 
		ON a.PF_CODE = b.PF_CODE 
GROUP BY
	a.PF_CODE 
ORDER BY
	"PERCENTAGE" DESC
	, a.PF_CODE DESC;