Examples

SELECT DEPT, AVG(SALARY) FROM STAFF
GROUP BY DEPT