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: