select
a.pf_code as CODE
,b.pf_name as NAME 
,round(
  100.0 * sum(case when a.category_code = '120' then a.amt else 0 end)
  / sum(case when a.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
;