Examine the description of the EMPLOYEES table:<br /> EMP_ID NUMBER(4) NOT NULL<br /> LAST_NAME VARCHAR2(30) NOT NULL<br /> FIRST_NAME VARCHAR2(30)<br /> DEPT_ID NUMBER(2)<br /> JOB_CAT VARCHARD2(30)<br /> SALARY NUMBER(8,2)<br /> Which statement shows the maximum salary paid in each job category of each department?（）

A、SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX (salary);

B、SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id,job_cat;

C、SELECT dept_id, job_cat, MAX(salary) FROM employees;

D、SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;

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