SELECT
   T1.PF_CODE AS "CODE"
  ,T2.PF_NAME AS "NAME"
  ,ROUND(CAST(SUM(CASE WHEN T1.CATEGORY_CODE = "120" THEN T1.AMT ELSE 0 END) AS REAL) / CAST(SUM(CASE WHEN T1.CATEGORY_CODE = "110" THEN T1.AMT ELSE 0 END) AS REAL) * 100,1) AS "PERCENTAGE"
FROM
  DRINK_HABITS AS T1
INNER JOIN
  PREFECTURE AS T2 ON T1.PF_CODE = T2.PF_CODE
WHERE
  T1.GENDER_CODE != 1
GROUP BY
  T1.PF_CODE
ORDER BY
   "PERCENTAGE" DESC
  ,"CODE" DESC