Hi, I'm using this to help learn PostgreSQL. I get this is based on SQLite so will be a little different.
When I run a query like:
SELECT name, city, MAX(age) FROM table GROUP BY city;
I get a return error saying "ERROR: column "table.name" must appear in the GROUP BY clause or be used in an aggregate function".
Any help with this? Do I need a different syntax for PostgreSQL? Thanks!