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
- s.project_id not 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