SELECT
  TMP.PF_CODE AS CODE, 
  PF.PF_NAME AS NAME,
  TMP.DRINK_AMT,
  TMP.ALL_AMT,
  ROUND(CAST(TMP.DRINK_AMT * 10000 / TMP.ALL_AMT AS REAL) / 100, 1) AS PERCENTAGE
FROM (
  SELECT
    PF_CODE, 
    SUM(CASE WHEN CATEGORY_CODE = '110' THEN AMT ELSE 0 END) AS ALL_AMT,
    SUM(CASE WHEN CATEGORY_CODE = '120' THEN AMT ELSE 0 END) AS DRINK_AMT
  FROM DRINK_HABITS
  WHERE CATEGORY_CODE IN ('110', '120')
  AND GENDER_CODE IN ('2', '3')
  GROUP BY PF_CODE
) TMP LEFT OUTER JOIN PREFECTURE PF ON PF.PF_CODE = TMP.PF_CODE
ORDER BY PERCENTAGE DESC, TMP.PF_CODE DESC