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