Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT emploee.[Name]
- FROM [Employed] as emploee, [Employed] as chief
- where emploee.Chief_Id = chief.Id
- group by [chief].Id having AVG([emploee].Salary) < [chief].Salary
- order by [emploee].[Chief_Id]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement