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