mysql把某字段多行值拼接成一行

原始数据：

code	name	z_date
1	aaa	20241220
1	aaa	20241221
1	aaa	20241222
2	bbb	20241219
2	bbb	20241220

输出结果：

code	name	z_date
1	aaa	20241220,20241221,20241222
2	bbb	20241219,20241220

SQL:

select  code,name,count(n),GROUP_CONCAT(z_date order by z_date asc  SEPARATOR  ', ') from z_data group by code,name order by 3 desc;