SQL SUM: Examples

Examples
Sample Database

#1

SELECT 
    SUM(salary)
FROM
    employees;

#2

SELECT 
    SUM(salary)
FROM
    employees
WHERE
    department_id = 5;

#3

SELECT
	department_id,
	SUM(salary)
FROM
	employees
GROUP BY
	department_id;

#4

SELECT
	e.department_id,
	department_name,
	SUM(salary)
FROM
	employees e
INNER JOIN departments d ON d.department_id = e.department_id
GROUP BY
	e.department_id;

#5

SELECT
	e.department_id,
	department_name,
	SUM(salary)
FROM
	employees e
INNER JOIN departments d ON d.department_id = e.department_id
GROUP BY
	e.department_id
ORDER BY
	SUM(salary) DESC;

#6

SELECT
	e.department_id,
	department_name,
	SUM(salary)
FROM
	employees e
INNER JOIN departments d ON d.department_id = e.department_id
GROUP BY
	e.department_id
HAVING
	SUM(salary) > 30000
ORDER BY
	SUM(salary) DESC;

Table List