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