select
DH.PF_CODE as CODE
,P.PF_NAME as NAME
,ROUND(
100.0 * sum(case DH.CATEGORY_CODE when '120' then DH.AMT else 0 end)/
sum(case DH.CATEGORY_CODE when '110' then DH.AMT else 0 end)
,1)
as PERCENTAGE
from
DRINK_HABITS as DH
inner join
PREFECTURE as P
on
DH.PF_CODE = P.PF_CODE
where
DH.GENDER_CODE in ('2','3')
group by
DH.PF_CODE
order by
PERCENTAGE desc
,DH.PF_CODE desc;