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