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

A.
SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP 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 job, MIN(salary), MAX(salary);

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

Explanation: