select
    d.PF_CODE as CODE,
    p.PF_NAME as NAME,
    round(total(case CATEGORY_CODE when '120' then AMT else 0 end) / total(case CATEGORY_CODE when '110' then AMT else 0 end) * 100, 1) as PERCENTAGE
from
    DRINK_HABITS d
inner join
    PREFECTURE p
    on p.PF_CODE = d.PF_CODE
where
    GENDER_CODE = '2'
    or
    GENDER_CODE = '3'
group by
    d.PF_CODE
order by
    PERCENTAGE desc,
    CODE desc;