Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Department.Name,
- SUM(Bonus.Amount) AS DepartmentTotalBonusSize
- FROM Department
- JOIN
- Employee ON Department.Id = Employee.DepartmentId
- JOIN
- Bonus ON Employee.ID = Bonus.EmployeeId;
Advertisement
Add Comment
Please, Sign In to add comment