select
    dh.PF_CODE AS CODE,
    pf1.PF_NAME AS NAME,
    round(SUM(CASE dh.CATEGORY_CODE WHEN "120" THEN CAST(dh.AMT as float)
                else 0 END)
          / SUM(CASE dh.CATEGORY_CODE WHEN "110" THEN CAST(dh.AMT as float)
                else 0 END)
          * 100, 1) AS PERCENTAGE
from
    DRINK_HABITS dh
inner join
    PREFECTURE pf1
on
    dh.PF_CODE = pf1.PF_CODE
where
    dh.GENDER_CODE <> "1"
group by
    dh.PF_CODE
order by
    PERCENTAGE desc,
    CODE desc