Question

To display the names of employees who earns more than the average salary of all
employees.
SELECT last_name, first_name
FROM employee
WHERE salary > AVG(salary);
Which change should you make to achieve the desired results?
Select one:
O Change the function in the WHERE clause.
O Use a subquery in the WHERE clause to compare the average salary value.
O Move the function to the SELECT clause and add a GROUP BY clause and a HAVING clause.
O Move the function to the SELECT clause and add a GROUP BY clause.​

Answer 1

Explanation:

Use a subquery in the WHERE clause to compare the average salary value.

please mark as best answer and thank me

Answer 2

Answer:

B. Use a subquery in the WHERE clause to compare the average salary value.

Explanation:

A subquery in a WHERE clause can be used to qualify a column against a set of rows.