Cadernos de Questões

Provas Favoritas

Filtros Salvos

Foi encontrada 1 questão.
#2332154

Tabela: EmployeeDetails


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);
Fale com IAgo
IAgo - Assistente IAProva
IA
Olá! Sou o IAgo, seu assistente aqui no IAProvatec 😊
Veja como posso te ajudar:
Agora