Which SQL statement should be used to retrieve the minimum and maximum salaries (SALARY) for each job code (JOB), sorted by job code, from a table named EMPLOYEE?

Which SQL statement should be used to retrieve the minimum and maximum salaries (SALARY) for each job code (JOB), sorted by job code, from a table named EMPLOYEE?
A. SELECT job, MIN(salary), MAX(salary)FROM employeeGROUP BY jobORDER BY job;
B. SELECT job, MIN(salary), MAX(salary)FROM employeeORDER BY job;
C. SELECT job, MIN(salary), MAX(salary)FROM employeeGROUP BY SALARYORDER BY job;
D. SELECT job, MIN(salary), MAX(salary)FROM employeeGROUP BY MIN(salary), MAX(salary)ORDER BY job;

Download Printable PDF. VALID exam to help you PASS.