Database Query Error:

Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_453689_1.s.time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

for query

SELECT SUM(distance) sum_dist, COUNT(distance) cnt_dist,  (s.part>0)  participated, time
				FROM mybo_strikes s
				WHERE time BETWEEN '2025-11-28 09:13:39' AND '2022-07-03 00:15:41'
				
				GROUP BY participated, DAYOFMONTH(time), HOUR(time), FLOOR(MINUTE(time) / 30)