// Show the salary sum according to the dept wise

SELECT Tbl_Emp.empname, Tbl_Emp.salary AS Amount, TBL_Dept.Deptname
FROM Tbl_Emp INNER JOIN
TBL_Dept ON Tbl_Emp.deptid = TBL_Dept.Deptid
order BY deptname desc
COMPUTE SUM(salary) BY deptname