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