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 ORDER BY job, MIN(salary),
MAX(salary);

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

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

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

Explanation: