SQL Sum

Example Table

We will use the following table named sales for our examples:

    CREATE TABLE sales (
        sale_id INT PRIMARY KEY,
        product_name VARCHAR(50),
        quantity INT,
        price DECIMAL(10, 2)
    );

    INSERT INTO sales (sale_id, product_name, quantity, price) VALUES
    (1, 'Laptop', 2, 1200.00),
    (2, 'Mouse', 5, 25.00),
    (3, 'Keyboard', 3, 45.00),
    (4, 'Monitor', 1, 300.00),
    (5, 'Chair', 4, 150.00);
    

Sales Table

Using the SQL SUM Function

The SQL SUM function is used to calculate the total sum of a numeric column. In this tutorial, we will demonstrate how to use the SUM function with the sales table.

Example: Calculating Total Sales Quantity

To calculate the total quantity of all products sold:

    SELECT SUM(quantity) AS total_quantity FROM sales;
    

Result:

Example: Calculating Total Sales Revenue

To calculate the total revenue from all sales:

    SELECT SUM(quantity * price) AS total_revenue FROM sales;
    

Result:

Example: Calculating Total Revenue by Product

To calculate the total revenue for each product:

    SELECT product_name, SUM(quantity * price) AS total_revenue
    FROM sales
    GROUP BY product_name;
    

Result: