select
      PF_CODE as CODE
    , PF_NAME as NAME
    , ROUND( ( (DRINK*1.0) / (TOTAL*1.0) )*100, 1) as PERCENTAGE
from
    (
    select
        PF_CODE
        , PF_NAME
        , sum(case when CATEGORY_CODE = '110' then AMT else 0 end) as TOTAL
        , sum(case when CATEGORY_CODE = '120' then AMT else 0 end) as DRINK
    from
        (
        select
            CATEGORY_CODE
            , PF_CODE
            , PF_NAME
            , sum(AMT) as AMT
        from
            (
            select
                DRINK_HABITS.CATEGORY_CODE
                , DRINK_HABITS.GENDER_CODE
                , DRINK_HABITS.PF_CODE
                , PREFECTURE.PF_NAME
                , DRINK_HABITS.AMT
            from DRINK_HABITS
                left outer join PREFECTURE using(PF_CODE)
            )
        where
            GENDER_CODE in (2,3)
        group by CATEGORY_CODE, PF_CODE, PF_NAME
        )
    group by PF_CODE, PF_NAME
    )
order by 
    PERCENTAGE desc, CODE desc