7. Joins & Subquery
To display the names of employees who earns more than the average salary of all employees. SELECT last_name, first_name FROMemployee WHEREsalary > AVG(salary); Which change should you make to achieve the desired results?
Move the function to the SELECT clause and add a GROUP BY claus
Use a subquery in the WHERE clause to compare the average salary valu
Change the function in the WHERE claus