select
    PREFECTURE.PF_CODE AS CODE,
    PREFECTURE.PF_NAME AS NAME,
    DRINK.PERCENTAGE AS PERCENTAGE
from
    (select
        PF_CODE,
        round(cast (sum(case when CATEGORY_CODE = '110' then AMT else 0 END) as real) / cast (sum(AMT) as real) *100,1) AS PERCENTAGE
    from
        DRINK_HABITS
    where
        GENDER_CODE = '2' or GENDER_CODE = '3'
    group by
        PF_CODE
    ) AS DRINK,
    PREFECTURE
where
    DRINK.PF_CODE = PREFECTURE.PF_CODE
order by
    DRINK.PERCENTAGE DESC,
    PREFECTURE.PF_CODE DESC
;