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