Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)DEPARTMENT_ID NUMBERSALARY NUMBERWhat is the correct syntax for an inline view? （） A.SELECT A.last_name, A.salary, A.department_id, B.maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE A.department_id = B.department_id AND A.salary < B.maxsal; B.SELECT A.last name, A.salary, A.department_id FROM employees a WHERE A.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees)) C.SELECT A.last_name, A.salary, A.department_id FROM employees a WHERE A.salary = (SELECT max(salary) FROM employees b WHERE A.department _ id = B.department _ id); D.SELECT A.last_name, A.salary, A.department_id FROM employees a WHERE (A.department_id, A.salary) IN (SELECT department_id, A.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);