SUM

Sum numeric values with SUM.

SUM returns the total of a column. It works with numeric columns.

SELECT SUM(price) FROM products;

This query gives the total of all prices.

SUM(price) is selected from products.

SUM — details

SUM skips NULL values. It errors on non-numeric columns.

For example, SELECT SUM(amount) FROM orders returns the total of all orders; with no rows the result is NULL, not 0.

Compute the total of prices in products with SUM(price).

Show example solution

SELECT SUM(price) FROM products;

Add SUM

SELECT ____(price) FROM products;

Show answer

SELECT SUM(price) FROM products;

Next lesson: AVG