为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】：win11
【CPU】:
【问题描述】*：GROUP BY项中不应包含集函数或子查询

SELECT 
	b.id as module_id,
	b.module_name,
	a.id as req_id,
	a.title as req_title,
	priority,
	a.status,
    d.case_id,
	d.title as bug_case_title,
      	(select IFNULL(TRUE_NAME,USERNAME) from sys_user t where t.USER_ID = a.CREATE_BY) as create_by,
	a.create_time,
	SUBSTR(a.finish_time,1,10) as finish_time
 FROM
	zt_requirement a
	LEFT JOIN zt_product_module b ON a.module_id = b.id
	LEFT JOIN zt_bug_case_relation c ON a.id = c.rela_id 
	AND type = 1
	LEFT JOIN zt_bug_case d ON c.case_id = d.case_id 
 WHERE
	a.del_flag = 0 
	group by b.id,
	b.module_name,
	a.id,
	a.title,
	priority,
	a.status,
	d.title,
	create_by,
	a.create_time,
	a.finish_time
	order by a.product_id,a.module_id,a.id

在group by语句中，把create_by去掉，就会提示不是group by 表达式。
数据库已开启兼容模式