SELECT
	P.PF_CODE AS CODE,
	P.PF_NAME AS NAME,
	ROUND((SUM(CASE WHEN CATEGORY_CODE = '120' THEN cast(AMT as double) ELSE 0 END) / SUM(CASE WHEN CATEGORY_CODE = '110' THEN AMT ELSE 0 END)) * 100,1) AS PERCENTAGE
FROM
	DRINK_HABITS D
INNER JOIN
    PREFECTURE P
ON
    D.PF_CODE = P.PF_CODE AND
    D.GENDER_CODE in ('2','3')
GROUP BY
    P.PF_CODE
ORDER BY 
    PERCENTAGE DESC,
	D.PF_CODE DESC