Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select e.emp_name
- from employees as e
- join salaries as s on s.EMPLOYEE_ID = e.employee_id
- where s.PROJECT_ID in (
- select s.project_id
- from employees as e
- join salaries as s on s.employee_id = e.employee_id
- where e.emp_name = 'WOLF'
- )
- group by e.emp_name
- having count (e.emp_name) >= (
- select count(s.project_id)
- from employees as e
- join salaries as s on s.employee_id = e.employee_id
- where e.emp_name = 'WOLF'
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement