select
    p.PF_CODE as CODE,
    p.PF_NAME as NAME,
    round(100 * 
        sum(cast(
            case when d.CATEGORY_CODE = 120 then d.AMT
            else 0 end as real))
        /
        sum(cast(
            case when d.CATEGORY_CODE = 110 then d.AMT 
            else 0 end as real)),1) as PERCENTAGE
from
    PREFECTURE as p
join
    DRINK_HABITS as d on d.PF_CODE = p.PF_CODE
where
    d.GENDER_CODE != "1"
group by
    CODE
order by
    PERCENTAGE desc,
    CODE desc