Questão de Desenvolvimento de Software

Com base no DER abaixo, qual a forma correta para criar uma query que mostre o último nome e o salário de todos os funcionários que tenham o Steve King como gerente?

A
select first_name, last_name, salary from employees where manager_id > (select employee_id from employees where first_name = 'Steven' and last_name = 'King')
B
from employees where manager_id not exists (select employee_id from employees where first_name = 'Steven' and last_name = 'King')
C
select first_name, last_name, salary from employees where manager_id not in(select employee_id from employees where first_name = 'Steven' and last_name = 'King')
D
select first_name, last_name, salary from employees where manager_id = (select employee_id from employees where first_name = 'Steven' and last_name = 'King')
E
select first_name, last_name, salary from employees where manager_id between (first_name = 'Steven' and last_name = 'King')

Comentários

U

Ainda não há comentários para esta questão.

Seja o primeiro a comentar!