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