select
    DH.PF_CODE as CODE,
    PF.PF_NAME as NAME,
    ROUND(100.0*SUM(
        CASE
            WHEN DH.CATEGORY_CODE = '120' THEN DH.AMT
            ELSE 0
        END
        )/SUM(
        CASE
            WHEN DH.CATEGORY_CODE = '110' THEN DH.AMT
            ELSE 0
        END
        ),1) as PERCENTAGE
from
    DRINK_HABITS as DH
    inner join PREFECTURE as PF
    on PF.PF_CODE = DH.PF_CODE
where
    DH.GENDER_CODE in ('2','3')
group by
    DH.PF_CODE
order by
    PERCENTAGE DESC,
    CODE DESC