Artificial Intelligence (AI) & Machine Learning Course for Managers

 Enroll Now

SQL Tutorial

49 / 59
   

Write and execute a query to list out managers names and count of employees reporting to them.

How many managers have more than one reportee?

INSTRUCTIONS

Do self join on emp to get employee and their manager names, then use 'group by' on manager and 'having count'.