Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT e1.EMPLOYEE_ID, e1.FIRST_NAME, COUNT(e1.HIRE_DATE),COUNT(e2.HIRE_DATE)
- FROM employees e1
- JOIN employees e2 ON e1.HIRE_DATE <e2.HIRE_DATE
- GROUP by e1.FIRST_NAME
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement