the sum of quantities for each unique customer id

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.

Leave a Comment

Your email address will not be published.

Scroll to Top