Advertisement
Artur123ff2

Untitled

Mar 25th, 2020
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.42 KB | None | 0 0
  1. select e.emp_name
  2. from employees as e
  3. join salaries as s on s.EMPLOYEE_ID = e.employee_id
  4. where s.PROJECT_ID in (
  5.     select s.project_id
  6.     from employees as e
  7.     join salaries as s on s.employee_id = e.employee_id
  8.     where e.emp_name = 'WOLF'
  9. )
  10. group by e.emp_name
  11. having count (e.emp_name) >= (
  12.     select count(s.project_id)
  13.     from employees as e
  14.     join salaries as s on s.employee_id = e.employee_id
  15.     where e.emp_name = 'WOLF'
  16. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement