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