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