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