select
    D.PF_CODE as CODE
    , P.PF_NAME as NAME
    , round(100 * sum(case when D.CATEGORY_CODE='120' then cast(D.AMT as real) else 0.0 end)
            / sum(case when D.CATEGORY_CODE='110' then cast(D.AMT as real) else 0.0 end), 1) as PERCENTAGE
from DRINK_HABITS as D
inner join PREFECTURE as P on D.PF_CODE = P.PF_CODE
where GENDER_CODE in ('2', '3')
group by D.PF_CODE
order by PERCENTAGE desc, CODE desc;