Skip to content

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?