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 dh.pf_code = pf.pf_code
where
        dh.gender_code in ("2","3")
group by dh.pf_code
order by PERCENTAGE desc,CODE desc;