This, to me, looks like it should return the department_id and AVG(salary) where the AVG(salary) is greater than $8000..... but the tutorial says it returns an error....
Why?
from Skillsoft SQL course - creating and manipulating group functions
Okay, so if this is synctactically incorrect.... how SHOULD it look? Do I need a subquery instead?