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;