select
    dh.pf_code as CODE
    , pf.pf_name as NAME
    , round(100.0 * sum(case dh.category_code when '120' then dh.amt else 0 end)/sum(case dh.category_code when '110' then dh.amt else 0 end),1) as PERCENTAGE
from DRINK_HABITS as dh
inner join prefecture as pf on pf.pf_code=dh.pf_code
where dh.gender_code in ('2','3')
group by dh.pf_code
order by percentage desc, dh.pf_code desc;