Write a query to find out which managers have more than 5 people on their team
I don't get what is wrong with my HAVING
SELECT MANAGERS.FIRST_NAME, MANAGERS.LAST_NAME FROM MANAGERS JOIN EMPLOYEES ON EMPLOYEES.MANAGER_ID = MANAGERS.ID GROUP BY MANAGERS.ID HAVING EMPLOYEES.MANAGER_ID >5;
Steven Parker177,674 Points
The manager's ID number probably won't be the same as the number of people they supervise. But did you notice that the instructions included the suggestion "If you need to use a count, use 'COUNT(1)'."?
You might consider that "suggestion" to also be a hint.
You can place a count after a group by?