为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:
【操作系统】：
【CPU】:
【问题描述】*：

对自定义列进行GROUP BY 出现无效列名问题

TRIGGERDAY 为 DATE_FORMAT(TRIGGER_TIME, ‘%Y-%m-%d’)的别名

SELECT DATE_FORMAT(TRIGGER_TIME, '%Y-%m-%d') AS TRIGGERDAY, 
       COUNT(HANDLE_CODE) AS TRIGGERDAYCOUNT
     , SUM(CASE
               WHEN trigger_code IN (0, 200)
                   AND handle_code = 0
                   THEN 1
               ELSE 0
    END) AS TRIGGERDAYCOUNTRUNNING
     , SUM(CASE
               WHEN handle_code = 200 THEN 1
               ELSE 0
    END) AS TRIGGERDAYCOUNTSUC
FROM XXL_JOB_QRTZ_TRIGGER_LOG
GROUP BY TRIGGERDAY