Grouping query

SELECT FirstName, LastName FROM EMPLOYEE
GROUP BY Department ;

This query returns the names of all employees, with the members of each depart- ment listed together as a group.