select 
    b.PF_CODE as CODE,
    b.PF_NAME as NAME,
    ROUND(
        (cast(sum(case when a.CATEGORY_CODE = '120' then a.AMT else 0 end) as REAL)
        /
        cast(sum(case when a.CATEGORY_CODE = '110' then a.AMT else 0 end) as REAL)
        )
        *
        100
        ,1
        ) as "PERCENTAGE"
from DRINK_HABITS a inner join PREFECTURE b
on a.PF_CODE = b.PF_CODE
where a.GENDER_CODE <> '1'
group by b.PF_CODE
order by PERCENTAGE desc,
    CODE desc
    ;