CREATE TABLE manufacturers (name VARCHAR2, Headquarter VARCHAR2, revenue 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"