with 
    sum_AMT as (
        select
            PF_CODE
            ,SUM(AMT) as AMT
        from DRINK_HABITS
        where CATEGORY_CODE = '110'
            and GENDER_CODE in ('2','3')
        group by PF_CODE
        )
    ,DRINK_AMT as (
        select
            PF_CODE
            ,SUM(AMT) as AMT
        from 
            DRINK_HABITS
        where 
            CATEGORY_CODE = '120'
            and GENDER_CODE	in ('2','3')
        group by PF_CODE
        )
    ,sub as (
        select
            DRINK_AMT.PF_CODE as PF_CODE
            ,round(cast(DRINK_AMT.AMT as float)*100/sum_AMT.AMT,1) as DR
        from DRINK_AMT
        inner join sum_AMT
            on DRINK_AMT.PF_CODE = sum_AMT.PF_CODE
        group by DRINK_AMT.PF_CODE
        )
select * from sub

select
    sub.PF_CODE as CODE
    ,PERCENTAGE.PF_NAME as NAME
    ,sub.DR as PERCENTAGE
from
    sub
    inner join PREFECTURE
    on sub.PF_CODE = PREFECTURE.PF_CODE
order by
    PERCENTAGE desc
    ,CODE desc