select
d.pf_code as "CODE",
p.pf_name as "NAME",
round( (cast(sum(case when category_code = '120' and gender_code in ('2', '3') then amt else 0 end) as real) / cast(sum(case when category_code = '110' and gender_code in ('2', '3') then amt else 0 end) as real)) * 100, 1) as "PERCENTAGE"
from
 drink_habits d
 inner join prefecture p
 on d.pf_code = p.pf_code
group by
 d.pf_code
order by
 round( (cast(sum(case when category_code = '120' and gender_code in ('2', '3') then amt else 0 end) as real) / cast(sum(case when category_code = '110' and gender_code in ('2', '3') then amt else 0 end) as real)) * 100, 1) desc,
 d.pf_code desc