Question

1. Com base no DER abaixo, escreva a sintaxe correta para selecionar o nome, o cargo e o salário de todos os empregados cujo salário seja maior que a média salarial de todos os empregados.


a. SELECT First_Name, Job_id, Salary
FROM Employees
WHERE Salary = (SELECT AVG(Salary)
FROM Employees)

b. SELECT First_Name, Job_id, Salary
FROM Employees
WHERE Salary > (SELECT AVG(Salary)
FROM Employees)

c. SELECT First_Name, Job_id, Salary
FROM Employees
WHERE Salary >= (SELECT AVG(Salary)
FROM Employees)

d. SELECT First_Name, Job_id, Salary
FROM Employees
WHERE Salary > (SELECT SUM(Salary)
FROM Employees)

e. SELECT First_Name, Job_id, Salary
FROM Employees
WHERE Salary > (SELECT MAX(Salary)
FROM Employees)

44abe082fc029ff69503fc686be41dcc.docx

Answer 1

Letra B.

WHERE Salary > (SELECT AVG(Salary)
Seleciona apenas os maiores que a média

Answer 2

Resposta:

SELECT First_Name, Job_id, Salary

FROM Employees

WHERE Salary > (SELECT AVG(Salary)

               FROM Employees)

Explicação:

LETRA B