with t as (
select
    PF_CODE,
    SUM(
        CASE WHEN CATEGORY_CODE = '110' THEN AMT ELSE 0 END
    ) as a,
    SUM(
        CASE WHEN CATEGORY_CODE = '120' THEN AMT ELSE 0 END
    ) as b
from DRINK_HABITS 
where GENDER_CODE in('2','3')
group by 1
)
select 
    t.PF_CODE as CODE,
    p.PF_NAME as NAME,
    ROUND(CAST(t.b as REAL) / CAST(t.a as REAL) * 100,1) as PERCENTAGE
from t inner join PREFECTURE as p on t.PF_CODE = p.PF_CODE
order by 3 desc, 1 desc