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' and GENDER_CODE in ('2', '3')) 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 1=1
--GENDER_CODE in ('2', '3')
and CATEGORY_CODE in ('110', '120')
-- and amt>0
group by D.PF_CODE
order by 3 desc, 1;