SELECT
    t1.PF_CODE AS CODE
   ,t2.PF_NAME AS NAME
   ,ROUND(CAST(t1.SUM_DAILY_AMT AS REAL) / CAST(t1.SUM_TOTAL_AMT AS REAL) * 100, 1) AS PERCENTAGE
FROM
   (
      (
         SELECT
             SUM(AMT) AS SUM_DAILY_AMT
            ,PF_CODE
         FROM
            DRINK_HABITS
         WHERE
                CATEGORY_CODE = '120'
            AND GENDER_CODE IN ('2','3')
         GROUP BY
            PF_CODE
      ) daily LEFT JOIN (
         SELECT
             SUM(AMT) AS SUM_TOTAL_AMT
            ,PF_CODE
         FROM
            DRINK_HABITS
         WHERE
                CATEGORY_CODE = '110'
            AND GENDER_CODE IN ('2','3')
         GROUP BY
            PF_CODE
      ) total ON (
         daily.PF_CODE = total.PF_CODE
      )
   ) AS t1 LEFT JOIN PREFECTURE AS t2 ON (
      t1.PF_CODE = t2.PF_CODE
   )
ORDER BY 
    PERCENTAGE DESC
   ,CODE DESC