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);
A.last_name,
B.salary,
C.department_id,
D.maxsal
E.department_id
F.department_id
G.salary
H.maxsal;
I.last
J.salary,
K.department_id
L.department_id
M.last_name,
N.salary,
O.department_id
P.salary
Q.department
R.department
S.last_name,
T.salary,
U.department_id
V.department_id,
W.salary)
X.salary)