select 
    p.PF_CODE as CODE,
    p.PF_NAME as NAME,
    round(cast(sum(dh2.AMT) as real)/cast(sum(dh1.AMT) as real)*100,1) as PERCENTAGE
from PREFECTURE as p
    inner join DRINK_HABITS as dh1 on p.PF_CODE = dh1.PF_CODE and dh1.CATEGORY_CODE = '110'
    inner join DRINK_HABITS as dh2 on p.PF_CODE = dh2.PF_CODE and dh2.CATEGORY_CODE = '120'
where 
    dh1.GENDER_CODE in ('2','3') and dh2.GENDER_CODE in ('2','3')
group by 
    CODE
order by
    PERCENTAGE desc,
    CODE desc;