-- https://topsic-contest.jp/contests/contest002/problems/contest002-3
SELECT S.PF_CODE AS CODE,
  PF_NAME AS NAME,
  PERCENTAGE
FROM (
    SELECT PF_CODE,
      ROUND(
        100.0 * SUM(
          CASE
            WHEN CATEGORY_CODE = 120 THEN AMT
            ELSE 0
          END
        ) / SUM(
          CASE
            WHEN CATEGORY_CODE = 110 THEN AMT
            ELSE 0
          END
        ),
        1
      ) AS PERCENTAGE
    FROM DRINK_HABITS
    GROUP BY PF_CODE
    ORDER BY PERCENTAGE DESC,
      PF_CODE DESC
  ) AS S
  JOIN PREFECTURE ON S.PF_CODE = PREFECTURE.PF_CODE;