SELECT SUM(aggregate_expression) FROM tables [WHERE conditions];
SELECT SUM(salary) AS "Total Salary" FROM [lidihuo].[dbo].[Employees] WHERE salary > 20000;