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