WITH combined_data AS (
  SELECT
    p.PF_CODE,
    p.PF_NAME,
    SUM(CASE WHEN CATEGORY_CODE = '120' THEN AMT ELSE 0 END) AS daily_drinkers_amt,
    SUM(CASE WHEN CATEGORY_CODE = '110' THEN AMT ELSE 0 END) AS total_surveyed_amt
  FROM DRINK_HABITS dh
  JOIN PREFECTURE p ON p.PF_CODE = dh.PF_CODE
  WHERE (GENDER_CODE = '2' OR GENDER_CODE = '3')
  GROUP BY p.PF_CODE, p.PF_NAME
)
SELECT
  PF_CODE AS CODE,
  PF_NAME AS NAME,
  ROUND((daily_drinkers_amt * 100.0 / total_surveyed_amt), 1) AS PERCENTAGE
FROM combined_data
ORDER BY PERCENTAGE DESC, CODE DESC;