Sum Employees salary according to depatments.
In sql server two tables is given, employee table and department table, and employee table contains approx 50 employees and his/her salary on each departments vise, and departments table contains department_id and department name, i want to to exit out sum of salary of every department separately according to each departments .