Examine the description of the EMPLOYEES table:<br /> <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080114592471196.jpg?sign=5c090004a5c773d852f99c5a35876ce8&t=62d71b27" /><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;