How do I sum up each Month of data for each product?

I have a set of data such as:

Date        Product    Volume
01-01-2020  A          5
02-01-2020  A          25
03-01-2020  B          20
02-01-2020  B          10
04-01-2020  C          5
02-02-2020  A          30
02-02-2020  B          25
01-02-2020  C          25
01-02-2020  C          40
04-02-2020  C          100
01-03-2020  A          5
01-03-2020  B          0
01-03-2020  A          50

​x
 
Date        Product    Volume01-01-2020  A          502-01-2020  A          2503-01-2020  B          2002-01-2020  B          1004-01-2020  C          502-02-2020  A          3002-02-2020  B          2501-02-2020  C          2501-02-2020  C          4004-02-2020  C          10001-03-2020  A          501-03-2020  B          001-03-2020  A          50​

The output would be something like:

Date        Product    Monthly Volume
01-01-2020  A          30
01-01-2020  B          40
01-01-2020  C          5
01-02-2020  A          30
01-02-2020  B          25
01-02-2020  C          165
01-03-2020  A          55
01-03-2020  B          0

 
Date        Product    Monthly Volume01-01-2020  A          3001-01-2020  B          4001-01-2020  C          501-02-2020  A          3001-02-2020  B          2501-02-2020  C          16501-03-2020  A          5501-03-2020  B          0​

Hopefully that makes sense. Thanks for all the help in advance =)

Answer

You can group by month and product, e.g.

SELECT Product, MONTH(Date), Sum(Volume) As Monthly Volume
FROM table
GROUP BY MONTH(Date), Product

 
SELECT Product, MONTH(Date), Sum(Volume) As Monthly VolumeFROM tableGROUP BY MONTH(Date), Product  ​

Advertisement

Answer