Assuming column hire date is a DATE data type, which SQL statement will retrieve the maximum salary (salary) and minimum salary(salary) for each job(job) from EMPLOYEE table for those hired(hiredate) before 1965?

Assuming column hire date is a DATE data type, which SQL statement will retrieve the maximum salary (salary) and minimum salary(salary) for each job(job) from EMPLOYEE table for those hired(hiredate) before 1965?
A .

B .

C .

D .

View Answer

Answer: D