MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE casemain (
c_casedate varchar(10),	
c_useMins int(20),	
c_sumCase int(20),	
c_sumPer int(20),
c_sumChat int(20),
c_sumRating int(20)
);
INSERT INTO casemain 
VALUES 
('2021-06-01',21,19,1,100,349),
('2021-06-15',21,19,1,100,349),
('2021-07-01',0,7,1,2,5);
SELECT month(c_casedate) as month, 
sum(c_useMins) as useMins, 
sum(c_sumCase) as sumCase,
sum(c_sumPer) as sumPer,
sum(c_sumChat) as sumChat,
sum(c_sumRating) as sumRating
FROM casemain
GROUP by month


month
useMins
sumCase
sumPer
sumChat
sumRating


6
42
38
2
200
698

7
0
7
1
2
5