select 
d.PF_CODE as CODE,
p.PF_NAME as NAME,
round(cast(sum(case d.CATEGORY_CODE when '120' then d.AMT else 0 end) as real) / cast(sum(case d.CATEGORY_CODE when '110' then d.AMT else 0 end) as real) * 100,1) as PERCENTAGE
from DRINK_HABITS d
join PREFECTURE p on d.PF_CODE = p.PF_CODE
where d.GENDER_CODE != 1
group by d.PF_CODE
order by PERCENTAGE desc, CODE desc;