MySQL 5.7

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

select version();


version()


5.7.39


CREATE TABLE table1
    (`ID` int, `date` datetime, `income` int, `payment` int, `profit` int)
;
    
INSERT INTO table1
    (`ID`, `date`, `income`, `payment`, `profit`)
VALUES
    (1, '2019-01-01 01:00:00', 100, 75, 25),
    (2, '2019-01-03 01:00:00', 200, 150, 50),
    (3, '2019-02-02 01:00:00', 350, 200, 150),
    (4, '2019-04-05 02:00:00', 100, 75, 25),
    (5, '2019-05-03 02:00:00', 500, 300, 200),
    (6, '2019-07-07 02:00:00', 200, 160, 40)
;

Records: 6  Duplicates: 0  Warnings: 0


Select
DATE_FORMAT(`date`,'%M %Y') MontnameYear,MIN(DATE_FORMAT(`date`,'%M')) MonthName, SUM(`income`) income
,SUM(`payment`) payment, SUM(`profit`) profit,MIN(`date`) mdate
FROM table1
GROUP BY DATE_FORMAT(`date`,'%M %Y')
ORDER by mdate;


MontnameYear
MonthName
income
payment
profit
mdate


January 2019
January
300
225
75
2019-01-01 01:00:00

February 2019
February
350
200
150
2019-02-02 01:00:00

April 2019
April
100
75
25
2019-04-05 02:00:00

May 2019
May
500
300
200
2019-05-03 02:00:00

July 2019
July
200
160
40
2019-07-07 02:00:00

MontnameYear	MonthName	income	payment	profit	mdate
January 2019	January	300	225	75	2019-01-01 01:00:00
February 2019	February	350	200	150	2019-02-02 01:00:00
April 2019	April	100	75	25	2019-04-05 02:00:00
May 2019	May	500	300	200	2019-05-03 02:00:00
July 2019	July	200	160	40	2019-07-07 02:00:00