SELECT a.PF_CODE as CODE
       ,b.PF_NAME as NAME
       , round((a.o / (select sum(cast ( AMT as real))
                       FROM DRINK_HABITS
                       WHERE 0=0
                       --and (GENDER_CODE = "1"
                       --or GENDER_CODE = "2") 
                       )) * 100 , 1) as PERCENTAGE
  FROM (SELECT PF_CODE
               ,SUM(cast( AMT as real)) as o
        FROM DRINK_HABITS
        WHERE CATEGORY_CODE = "120"
        and (GENDER_CODE = "1"
        or GENDER_CODE = "2")
        GROUP BY PF_CODE
        ) as a
 
  join PREFECTURE as b
    on a.PF_CODE = b.PF_CODE
    
  order by PERCENTAGE desc
           ,a.PF_CODE desc