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;