SELECT name ,  max(revenue) ,  Headquarter FROM manufacturers GROUP BY Headquarter
SELECT name ,  max(revenue) ,  Headquarter FROM manufacturers GROUP BY Headquarter <table_name> : Manufacturers col : Code | Name | Headquarter | Founder | Revenue row 1 : 1 | Sony | Tokyo | Andy | 120 row 2 : 2 | Creative Labs | Austin | Owen | 100 row 3 : 3 | Hewlett-Packard | Los Angeles | James | 50 row 4 : 4 | Iomega | Beijing | Mary | 200 row 5 : 5 | Fujitsu | Taiwan | John | 130 row 6 : 6 | Winchester | Paris | Robert | 30
col : Name | max(revenue) | Headquarter row 1 : Creative Labs | 100 | Austin row 2 : Iomega | 200 | Beijing row 3 : Hewlett-Packard | 50 | Los Angeles row 4 : Winchester | 30 | Paris row 5 : Fujitsu | 130 | Taiwan row 6 : Sony | 120 | Tokyo