我正在尝试写一个sql查询,根据去年每个部门由于新员工的工资增加了多少。表结构是员工(empno,deptno,msal,hiredate)SELECT sum(msal) FROM employees GROUP BY deptno;
以及如何从过去一年被雇佣的人那里获得工资SELECT sum(msal) FROM employees WHERE hiredate > (DATEADD(year, -1, GETDATE()))
我希望能够从两个SELECT查询中获取在SUM()中生成的两个值,然后减去这两个值,从而得到结果(OutstandingFunds)。下面是我的两个SELECT查询:SELECT SUM(Cf.Amount) AS ClearedFundsSELECT Amount FROM PAYMENT1 WHERE= "Cleare