Advertisement
Artur123ff2

Untitled

Mar 25th, 2020
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.47 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. e.emp_name not in (
  6.     select distinct e.emp_name
  7.     from employees as e
  8.     join salaries as s on s.employee_id = e.employee_id
  9.     where e.emp_name like 'W%' and s.project_id in(
  10.         select s.project_id
  11.         from employees as e
  12.         join salaries as s on s.employee_id = e.employee_id
  13.         where e.emp_name = 'Wolf'
  14.     )
  15. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement