Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select e.employee_id, e.last_name, e.salary
- from employees e join employees t on e.department_id=t.department_id
- having e.salary>avg(e.salary) and lower(t.last_name) like '%t%'
- group by e.employee_id, e.last_name, e.salary;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement