Which of the following statements are equivalent

[general9000]

En esta pregunta del examen de certificacion oracle
nos piden encontrar 2 sentencias equivalentes



Which of the following statements are equivalent? (Choose two answers.)

a) select employee_id from employees e join departments d on e.department_id= d.department_id
where e.salary < (select min(salary) from employees) and d.department_id=10;

b) select employee_id from employees
where salary < (select min(salary) from employees where department_id=10);

c) select employee_id from employees
where salary < all (select salary from employees where department_id=10);

d) select employee_id from employees
where salary not >= any (select salary from employees where department_id=10);


Lo que inicialmente llega a pensar en probar las combinaciones
A con B
A con C
A con D

luego

B con C
B con D

luego

C con D


Que estrategia usarían ustedes.???

GRacias!!