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 employee
GROUP BY job
ORDER BY job;

B.
SELECT job, MIN(salary), MAX(salary)
FROM employee
ORDER BY job;

C.
SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY SALARY
ORDER BY job;

D.
SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY MIN(salary), MAX(salary)
ORDER BY job;

Explanation: