select * from(
select
    p.PF_CODE as CODE
    ,p.PF_NAME as NAME
    ,ROUND(cast(dh_120.amt as REAL)/cast(dh_110.amt as REAL) * 100,1) as PERCENTAGE
from PREFECTURE p
    left join (
        select
            sum(AMT) as amt
            ,PF_CODE
        from DRINK_HABITS
        where
            CATEGORY_CODE = '110'
            and GENDER_CODE in ('2','3')
        group by
            PF_CODE
    ) dh_110
        on p.PF_CODE = dh_110.PF_CODE
    left join
    (
        select
            sum(AMT) as amt
            ,PF_CODE
        from DRINK_HABITS
        where
            CATEGORY_CODE = '120'
            and GENDER_CODE in ('2','3')
        group by
            PF_CODE
    ) dh_120
        on p.PF_CODE = dh_120.PF_CODE
    where
        dh_110.amt is not null
)
order by
    PERCENTAGE desc
    ,CODE desc