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

Find the name and revenue of the company that earns the highest revenue in each city.
SELECT name, MAX(revenue), headquarter FROM manufacturers GROUP BY headquarter
SELECT "name", MAX("revenue"), "headquarter" FROM "manufacturers" GROUP BY "headquarter"