WHERE or HAVING?
You want departments where the average salary is above 50000, counting only employees hired after 2020.
Which clause does each condition belong in?
You want departments where the average salary is above 50000, counting only employees hired after 2020.
Which clause does each condition belong in?