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

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"