Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select distinct e.emp_name
- from employees as e
- join salaries as s on s.employee_id = e.employee_id
- where e.emp_name like 'W%' and
- e.emp_name not in (
- select distinct e.emp_name
- from employees as e
- join salaries as s on s.employee_id = e.employee_id
- where e.emp_name like 'W%' and 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'
- )
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement