SELECT 
	d.Name, 
	d.Id, 
	(SELECT SUM(bns.Amount) FROM dbo.Employee emp
	JOIN dbo.Bonus bns ON emp.Id = bns.EmployeeId
	 WHERE emp.DepartmentId = d.Id)  AS DepartmentTotalBonusSize
		FROM dbo.Department d