select
    PF_CODE as CODE
    , PF_NAME as NAME
    ,round(sum(case when CATEGORY_CODE = '120' then AMT else 0 end) / cast(sum(case when CATEGORY_CODE = '110' then AMT else 0 end) as float) * 100, 1) as PERCENTAGE
from
    DRINK_HABITS
    left join
    PREFECTURE
    using(PF_CODE)
where
    1=1
    and GENDER_CODE in ('2','3')
group by
    PF_CODE, PF_NAME
order by
    PERCENTAGE desc, PF_CODE desc