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