Advertisement
Artur123ff2

Untitled

Mar 25th, 2020
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.28 KB | None | 0 0
  1. select distinct e.emp_name
  2. from employees as e
  3. join salaries as s on s.employee_id = e.employee_id
  4. where e.emp_name like 'W%' and
  5. s.project_id not in (
  6.     select s.project_id
  7.     from employees as e
  8.     join salaries as s on s.EMPLOYEE_ID = e.employee_id
  9.     where e.emp_name = 'WOLF'
  10. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement