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