SELECT name, MAX(revenue), Headquarter FROM manufacturers GROUP BY Headquarter
Temukan nama dan pendapatan perusahaan yang mendapatkan pendapatan tertinggi di setiap kota.
CREATE TABLE manufacturers (name VARCHAR, Headquarter VARCHAR, revenue INTEGER)