SELECT 
 B.PF_CODE as CODE,
 B.PF_NAME as NAME,
 round(cast(sum(case when A.CATEGORY_CODE = '120' then A.AMT else 0 end) as REAL) / cast(sum(case when A.CATEGORY_CODE = '110' then A.AMT else 0 end) as REAL) * cast(100 as REAL), 1) as PERCENTAGE
FROM 
 DRINK_HABITS as A
JOIN
 PREFECTURE as B
ON A.PF_CODE = B.PF_CODE
WHERE 
 GENDER_CODE <> '1'
GROUP BY
 A.PF_CODE, B.PF_NAME
ORDER BY
 PERCENTAGE desc, CODE desc