select 
DH.PF_CODE as CODE
,PF.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 PF
on DH.PF_CODE = PF.PF_CODE
where DH.GENDER_CODE in ('2','3') 
group by DH.PF_CODE
order by PERCENTAGE desc , DH.PF_CODE desc