select
    d.PF_CODE as CODE
    ,p.PF_NAME as NAME
    ,ROUND( 
        100.0*SUM( 
            case d.CATEGORY_CODE when '120' THEN d.AMT else 0 end) 
            / SUM(case d.CATEGORY_CODE when '110' THEN d.AMT else 0 end) 
        , 1
    ) as PERCENTAGE 
from
    DRINK_HABITS as d 
    inner join PREFECTURE as p 
        on p.PF_CODE = d.PF_CODE 
where
    d.GENDER_CODE IN ('2', '3') 
group by
    d.PF_CODE 
order by
    PERCENTAGE DESC
    , d.PF_CODE DESC
;