Databases SQL Reporting by Example Day 3: Getting Good at Grouping Day 3: Final Exam

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;

2 Answers

Steven Parker
Steven Parker
177,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. :wink:

You can place a count after a group by?

Steven Parker
Steven Parker
177,674 Points

In particular, you can use it in a HAVING clause.