SELECT 
DH.PF_CODE CODE,
PR.PF_NAME NAME,
ROUND(100.0 * SUM(CASE  WHEN DH.CATEGORY_CODE = 120 THEN DH.AMT ELSE 0 END)/
SUM(CASE WHEN DH.CATEGORY_CODE = 110 THEN DH.AMT ELSE 0 END),1)
AS PERCENTAGE

FROM DRINK_HABITS DH 
INNER JOIN PREFECTURE PR 
ON DH.PF_CODE = PR.PF_CODE
WHERE GENDER_CODE IN (2,3)
GROUP BY DH.PF_CODE
ORDER BY PERCENTAGE DESC
,DH.PF_CODE DESC;