SELECT
 D.PF_CODE AS CODE,
 P.PF_NAME AS NAME,
 D.SUM /
 (SELECT SUM(SUM) AS SUM_EVERYDAY
 FROM D
 WHERE CATEGORY_CODE = '120'
 GROUP BY PF_CODE) * 100
 FROM
 (SELECT
  CATEGORY_CODE,
  PF_CODE,
  SUM(AMT) AS SUM
  FROM DRINK_HABITS
  GROUP BY PF_CODE) AS D
 JOIN PREFECTURE AS P
 ON D.PF_CODE = P.PF_CODE;