SELECT DRINK_HABITS.PF_CODE AS CODE
       ,PF_NAME AS NAME
       ,ROUND((CAST(EVERYDAY AS REAL)/CAST(TOTAL AS REAL))*100 , 1) AS PERCENTAGE
  FROM (SELECT PF_CODE
               ,SUM(CASE CATEGORY_CODE
                      WHEN '120' THEN AMT ELSE 0 END) AS EVERYDAY
               ,SUM(CASE CATEGORY_CODE
                      WHEN '110' THEN AMT ELSE 0 END) AS TOTAL
          FROM DRINK_HABITS
         WHERE GENDER_CODE <> '1'
         GROUP BY DRINK_HABITS.PF_CODE) AS DRINK_HABITS
  JOIN PREFECTURE
    ON DRINK_HABITS.PF_CODE = PREFECTURE.PF_CODE
 
 ORDER BY PERCENTAGE DESC,CODE DESC