How to (MySQL) multiply columns and then the sum rows?

You can simply put the formula (expression) inside SUM:

SELECT payment_id, SUM(`unit cost` * quantity) AS total
FROM myTable
GROUP BY payment_id

SELECT 
    payment_id, 
    SUM(subtotal) AS total
 FROM(
    SELECT
        payment_id,
        (unit_cost * quantity) AS subtotal
) AS t1
GROUP BY 
payment_id

SELECT payemnt_id, SUM(`unit cost` * quantity) as total
FROM Table1
GROUP BY payemnt_id

Tags:

Mysql

Related