GroupBy styntax violation error

[alkadoHs]

I have these codes that read Orders per day for the week:

But, I'm getting this error **SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mauzodata.orders.created_at' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select date_format(created_at, '%Y-%m-%d') as date, sum(paid) as aggregate from orders where created_at between 2024 -03 -18 00: 00: 00 and 2024 -03 -24 23: 59: 59 group by date order by date asc**

[tjodalv]

Disable only_full_group_by mode in your MySQL server

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

[alkadoHs]

Thank for your response. I got the answer, it was because of the conflict on my orders table, it contains date column and created_at column. But after deleting date column now it works fine.