Questão de Banco de Dados

Com base no seguinte DER:

Qual é a forma CORRETA para criar uma query que mostre o último nome e salário de todos os funcionários que tenham Steven King como gerente?

A

select first_name, last_name, salary from employees where manager_id not exists (select employee_id from employees where First_Name = 'Steven' And last_name ='King')

B

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')

C

select first_name, last_name, salary from employees where manager_id> (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 between ( First_Name = 'Steven' And last_name ='King')

E

select first_name, last_name, salary from employees where manager_id = (select employee_id from employees where First_Name = 'Steven' And last_name ='King')

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

Seja o primeiro a comentar!

Aulas em vídeo Em breve

00:00

Tópicos Relacionados