CREATE TABLE manufacturers (code DECIMAL, name TEXT, headquarter TEXT, founder TEXT, revenue DECIMAL)
CREATE TABLE products (code DECIMAL, name TEXT, price DECIMAL, manufacturer DECIMAL)

What are the names and revenues of the companies with the highest revenues in each headquarter city?
SELECT name, MAX(revenue), headquarter FROM manufacturers GROUP BY headquarter
SELECT "name", MAX("revenue"), "headquarter" FROM "manufacturers" GROUP BY "headquarter"