SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX (salary);
SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id,job_cat;
SELECT dept_id, job_cat, MAX(salary) FROM employees;
SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;
SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept _ id job _ cat salary;