SELECT
DH.PF_CODE AS CODE,
PR.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 AS DH

INNER JOIN PREFECTURE AS PR
ON PR.PF_CODE = DH.PF_CODE

WHERE DH.GENDER_CODE IN('2','3')

GROUP BY DH.PF_CODE

ORDER BY 
PERCENTAGE DESC,
DH.PF_CODE DESC;