WHERE department_id = 100);
A.It executes successfully and gives the names and minimum salary greater than department 100 of all employees
B.It executes successfully and gives the salaries of the employees in department 100
C.It executes successfully and gives the names and minimum salaries of all the employees.
D.It throws an error.
Answer:A
WHERE department_id = 100);
A.It executes successfully and gives the names and minimum salary greater than department 100 of all employees B.It executes successfully and gives the salaries of the employees in department 100 C.It executes successfully and gives the names and minimum salaries of all the employees. D.It throws an error.