Tabela: EmployeeDetails Empid FullName Managerld DateOfJoining 121 John Snow 321 01/31/2014 321 Walter White 986 01/30/2015 421 Kuldeep Rana 876 27/11/2016 Tabela: EmployeeSalary Empid Project Salary 121 P1 8000 321 P2 1000 421 P1 12000 Considerando as tabelas apresentadas, qual é a query que retorna os nomes dos empregados que ganham salário maior ou igual a 5.000 e menor ou igual a 10.000?

SELECT FullName FROM EmployeeDetails WHERE Empid IN (SELECT Empid FROM EmployeeSalary WHERE Salary BETWEEN 5000 AND 10000);

SELECT Empid FROM EmployeeDetails WHERE Empid IN (SELECT Empid FROM EmployeeSalary WHERE Salary BETWEEN 5000 AND 10000);

SELECT FullName FROM EmployeeSalary WHERE Empid IN (SELECT Empid FROM EmployeeSalary WHERE Salary BETWEEN 5000 AND 10000);

SELECT FullName FROM EmployeeDetails WHERE Empid IN (SELECT Empid FROM EmployeeDetails WHERE Salary BETWEEN 5000 AND 10000);

SELECT FullName FROM EmployeeDetails WHERE Empid WHERE (SELECT Empid FROM EmployeeSalary WHERE Salary BETWEEN 5000 AND 10000);

Questão 2098915

Tecnologia da Informação · 2018

Questão

ID 2098915

Disciplina: Tecnologia da Informação

Assunto: Select

Ano: 2018 Banca: IADES - Instituto Americano de Desenvolvimento Órgão: Agência de Regulação e Controle de Serviços Públicos do Pará

Tabela: EmployeeDetails

Empid	FullName	Managerld	DateOfJoining
121	John Snow	321	01/31/2014
321	Walter White	986	01/30/2015
421	Kuldeep Rana	876	27/11/2016

Tabela: EmployeeSalary

Empid	Project	Salary
121	P1	8000
321	P2	1000
421	P1	12000

Considerando as tabelas apresentadas, qual é a query que retorna os nomes dos empregados que ganham salário maior ou igual a 5.000 e menor ou igual a 10.000?

Alternativa A:
SELECT FullName FROM EmployeeDetails WHERE Empid IN (SELECT Empid FROM EmployeeSalary WHERE Salary BETWEEN 5000 AND 10000);
Alternativa B:
SELECT Empid FROM EmployeeDetails WHERE Empid IN (SELECT Empid FROM EmployeeSalary WHERE Salary BETWEEN 5000 AND 10000);
Alternativa C:
SELECT FullName FROM EmployeeSalary WHERE Empid IN (SELECT Empid FROM EmployeeSalary WHERE Salary BETWEEN 5000 AND 10000);
Alternativa D:
SELECT FullName FROM EmployeeDetails WHERE Empid IN (SELECT Empid FROM EmployeeDetails WHERE Salary BETWEEN 5000 AND 10000);
Alternativa E:
SELECT FullName FROM EmployeeDetails WHERE Empid WHERE (SELECT Empid FROM EmployeeSalary WHERE Salary BETWEEN 5000 AND 10000);

Estatísticas Cadernos

Questão 2098915

Continue estudando na plataforma