# 
#  Overview
The **`SUM()` function** is used to return the sum of the specified column that contains numeric values.

##
## Syntax 


```sql
SELECT SUM(column)
FROM table
WHERE condition;
```

School

align-center

CREATE DATABASE name;

CREATE TABLE School (
    ClassID int,
    NumberOfStudents int
);

INSERT INTO School
VALUES (1, 25);

INSERT INTO School
VALUES (2, 20);

INSERT INTO School
VALUES (3, 15);

SELECT *
FROM School;

SELECT SUM(NumberOfStudents)
FROM School;

This function finds the sum of the `NumberOfStudents` numeric column.

How to find the sum of a column in SQL

SUM() returns the sum of numeric values in a column using SELECT SUM(column) FROM table WHERE condition.

How to find the sum of a column in SQL

Overview

Syntax

School

Finding the sum of a column