select d.pf_code as CODE , p.pf_name as NAME,
round(cast(sum(d.amt) as real)*100/cast(sum(d2.amt) as real),1)
as PERCENTAGE
from 
DRINK_HABITS d
inner join 
DRINK_HABITS d2
on d.pf_code=d2.pf_code and d.category_code='120' and d2.category_code='110'
 inner join 
PREFECTURE p
on d.pf_code=p.pf_code
where d.gender_code in ('2','3')
group by 1,2
order by PERCENTAGE desc,CODE desc;