Aggregate Functions and Grouping

SELECT Office, Count(*)

FROM Employee

GROUP BY Office

SELECT Office, Status, Max(Salary)

FROM Employee

GROUP BY Office, Status

To view the groupings, you must also select them!