SELECT
     TEMP.PF_CODE AS "CODE"
    ,TEMP.PF_NAME AS "NAME"
    ,ROUND(((SUM(TEMP.EVERY) * 1.0) / SUM(TEMP.TOTAL)) * 100.0, 1) AS "PERCENTAGE"
FROM
(
   SELECT
       DH.PF_CODE
      ,P.PF_NAME
      ,CASE
         WHEN DH.CATEGORY_CODE = '110' THEN SUM(DH.AMT)
         ELSE 0
       END AS "TOTAL"
      ,CASE
         WHEN DH.CATEGORY_CODE = '120' THEN SUM(DH.AMT)
         ELSE 0
       END AS "EVERY"
   FROM
      DRINK_HABITS DH
   INNER JOIN
      PREFECTURE P
   ON
      DH.PF_CODE = P.PF_CODE
   WHERE
      DH.GENDER_CODE IN ('2', '3')
   GROUP BY
       DH.PF_CODE
      ,CATEGORY_CODE
) AS "TEMP"
GROUP BY
   "TEMP".PF_CODE
ORDER BY
    "PERCENTAGE" DESC
   ,"CODE" DESC