Just group by
and sum
:
select customerID, sum(OrderedQuantity) total_ordered
from productOrders
group by customerID
CLICK HERE to find out more related problems solutions.
Just group by
and sum
:
select customerID, sum(OrderedQuantity) total_ordered
from productOrders
group by customerID
CLICK HERE to find out more related problems solutions.