Which SQL statement should be used to select the minimum and maximum salaries
(SALARY), by job code (JOB), from a table EMPLOYEE?
![PrepAway - Latest Free Exam Questions & Answers](https://www.briefmenow.org/img/pa5.jpg)
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: