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 = "2"
                       or GENDER_CODE = "3")
                       and CATEGORY_CODE = "110"
                       )) * 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 = "2"
        or GENDER_CODE = "3")
        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;