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