select
DH.PF_CODE as CODE,
PF.PF_NAME as NAME,
ROUND(
CAST(SUM(IIF(CATEGORY_CODE = 120, AMT , 0)) AS FLOAT) *100 /
SUM(IIF(CATEGORY_CODE = 110, AMT , 0))
,1)
as PERCENTAGE

from
DRINK_HABITS AS DH
LEFT JOIN PREFECTURE AS PF
USING (PF_CODE)

WHERE GENDER_CODE IN (2,3)
GROUP BY NAME,CODE
ORDER BY 3 DESC,1 DESC
;