select
    PRF.PF_CODE as CODE
,   PRF.PF_NAME as NAME
,   round(cast(sum(
        case DH.CATEGORY_CODE
            when '120' then DH.AMT
            else 0
        end
    ) as real)
    /
    sum(
        case DH.CATEGORY_CODE
            when '110' then DH.AMT
            else 0
        end
    )
    * 100, 1) as PERCENTAGE
from
    DRINK_HABITS DH
,   PREFECTURE PRF
where
    DH.PF_CODE = PRF.PF_CODE
and DH.GENDER_CODE in ('2','3')
group by
    PRF.PF_CODE
order by
    PERCENTAGE desc
,   CODE desc