CREATE TABLE manufacturers (code NUMBER, name CLOB, headquarter CLOB, founder CLOB, revenue NUMBER)
CREATE TABLE products (code NUMBER, name CLOB, price NUMBER, manufacturer NUMBER)

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"