List the maximum salary of employee grouped by their department number.
SELECT deptno, MAX(sal) AS max_salary FROM EMPL GROUP BY deptno;
+--------+------------+ | deptno | max_salary | +--------+------------+ | 20 | 3000 | | 30 | 2850 | | 10 | 5000 | +--------+------------+
