Using sum function in mysql for two diffrenet conditions

This article is tagged with: Using sum function in mysql for two diffrenet conditions and mysql

sum mysql column

SELECT sum( mark ) FROM `student`

using sum function in mysql for two diffrenet conditions

SELECT
SUM(CASE
WHEN status = 'Shipped' THEN quantityOrdered
END) qty_shipped,
SUM(CASE
WHEN status = 'Resolved' THEN quantityOrdered
END) qty_resolved,
SUM(CASE
WHEN status = 'Cancelled' THEN quantityOrdered
END) qty_cancelled,
SUM(CASE
WHEN status = 'On Hold' THEN quantityOrdered
END) qty_on_hold,
SUM(CASE
WHEN status = 'Disputed' THEN quantityOrdered
END) qty_on_disputed,
SUM(CASE
WHEN status = 'In Process' THEN quantityOrdered
END) qty_in_process
FROM
orderdetails
INNER JOIN
orders USING (orderNumber);

This article is tagged with: Using sum function in mysql for two diffrenet conditions and mysql