Converting from InfluxQL to SQL (flightSQL) in InfluxDB 3.0

I have also tried querying from influxdb.
The moment I add group by:

SELECT *
FROM "Conca"
WHERE
time >= now() - interval '30 days'
AND
("regs" IS NOT NULL)
GROUP BY "ID"

I get the error:

executing query: failed to create Flight record reader: arrow/flight: could not create flight reader: arrow/ipc: could not read schema from stream: arrow/ipc: could not read message schema: rpc error: code = InvalidArgument desc = Error while planning query: Error during planning: Projection references non-aggregate values: Expression Conca.address could not be resolved from available columns: Conca.ID

However if I don’t add the groupby statement and I use the query modifier everything works. But only on the inflkuxdb’s data explorer window…

Could somebody take a look? Because between this issue and the fact that InfluxQL is not working either I’m paying AWS for something unusable :smiling_face_with_tear: