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