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