SELECT
  a.pf_code AS "CODE",
  c.pf_name AS "NAME",
  ROUND(CAST(sum(a.amt) AS REAL) / CAST(sum(b.amt) AS REAL) * 100, 1) as "PERCENTAGE"
FROM
  (
    SELECT
      *
    FROM
      drink_habits
    WHERE
      category_code = '120'
  ) a
  JOIN (
    SELECT
      *
    FROM
      drink_habits
    WHERE
      category_code = '110'
  ) b ON a.pf_code = b.pf_code
  JOIN prefecture c ON a.pf_code = c.pf_code
WHERE
  a.gender_code = '2'
  OR a.gender_code = '3'
GROUP BY
  a.pf_code
order by "PERCENTAGE" DESC, "CODE" DESC;