WITH SUBSUM AS (
    SELECT
        PF_CODE
      , SUM(CASE WHEN CATEGORY_CODE = '110' THEN AMT ELSE 0 END) AS SUM_ALL
      , SUM(CASE WHEN CATEGORY_CODE = '120' THEN AMT ELSE 0 END) AS SUM_EVERY
    FROM
        DRINK_HABITS
    WHERE
        GENDER_CODE IN ('2', '3')
    GROUP BY
        PF_CODE
)
SELECT
    T1.PF_CODE AS "CODE"
  , M1.PF_NAME AS "NAME"
  , ROUND(CAST(T1.SUM_EVERY AS REAL) / CAST(T1.SUM_ALL AS REAL) * 100, 1) AS "PERCENTAGE"
FROM
    SUBSUM T1
    LEFT OUTER JOIN PREFECTURE M1
        ON T1.PF_CODE = M1.PF_CODE
ORDER BY
    PERCENTAGE DESC
  , CODE       DESC
;