I have two tables with names empl and dep
Empl has 4 columns
Name emp_No salary dep_no(foreign key)
Dep has three columns
Dep_no(primary key) Dep_name NO_of_emp
Now i want to retrieve sum of salary of each department grouped by depart name.