What is wrong with this query ?

Have this query;

SELECT regdate
, MAX(id) AS id
FROM gpstrackers
WHERE regdate BETWEEN (‘2021-11-22 03:00’ AND  ‘2021-11-22 09:00’)
GROUP BY flight

Gives me this error;

SQL-spørring: Dokumentasjon


SELECT regdate, flight
, MAX(id) AS id
FROM gpstrackers
WHERE regdate BETWEEN (‘2021-11-22’ AND  ‘2021-11-22’)
GROUP BY flight LIMIT 0, 25


#1064 - Something is wrong in your syntax nær 'GROUP BY flight LIMIT 0, 25' på linje 5

What is wrong ?