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