select D.PF_CODE                                                        CODE,
       P.PF_NAME                                                        NAME,
       --sum(case when CATEGORY_CODE = '110' then amt else 0 end),
       round(cast(sum(case when CATEGORY_CODE = '120' then amt else 0 end) as real) /
        cast(sum(case when CATEGORY_CODE = '110' then amt else 0 end) as real) * 100,1) PERCENTAGE
from DRINK_HABITS as D
         left join PREFECTURE as P on D.PF_CODE = P.PF_CODE
where GENDER_CODE in ('2', '3')
-- and amt>0
group by D.PF_CODE

order by 3 desc, 1;