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