Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT e.FIRST_NAME, COUNT( man.MANAGER_ID)
- FROM employees e
- LEFT JOIN employees man ON e.EMPLOYEE_ID = man.MANAGER_ID
- GROUP BY e.FIRST_NAME
- ORDER BY e.FIRST_NAME ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement