select
a.pf_code as CODE
,b.pf_name as NAME
,round(100.0 * sum(
  case when 
  category_code = '120'
   then a.amt
  else
   0
  end) /
  sum(case when
   category_code = '110'
     then a.amt 
  else
    0
  end
) ,1) as PERCENTAGE
from
drink_habits a
inner join
prefecture b
on
a.pf_code = b.pf_code
where
a.gender_code in('2','3')
group by
a.pf_code
order by
PERCENTAGE desc
,CODE desc
;