MySQL 5.6

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

select version();


version()


5.6.51


CREATE TABLE test (
    end_date date,
    sales int,
    index(end_date)
);

INSERT INTO test (end_Date, sales)
VALUES ('2022-01-01',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-01',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-02',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-02',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-03',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-04',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-05',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-06',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-07',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-08',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-08',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-09',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-10',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-11',10);
INSERT INTO test (end_Date, sales)
VALUES ('2022-01-12',10);
SELECT
    s.end_date,
    s.sales,
    SUM(CASE WHEN t.end_date <= s.end_date
             THEN t.sales
        END) prev_sales,
    SUM(CASE WHEN t.end_date >= s.end_date 
             THEN t.sales
        END) after_sales
FROM (
    SELECT
        end_date,
        SUM(sales) sales
    FROM test
    GROUP BY end_date
) s
JOIN test t ON t.end_date BETWEEN DATE_SUB(s.end_Date, INTERVAL 1 day) AND DATE_ADD(s.end_Date, INTERVAL 1 day)
GROUP BY end_date


end_date
sales
prev_sales
after_sales


2022-01-01
20
20
40

2022-01-02
20
40
30

2022-01-03
10
30
20

2022-01-04
10
20
20

2022-01-05
10
20
20

2022-01-06
10
20
20

2022-01-07
10
20
30

2022-01-08
20
30
30

2022-01-09
10
30
20

2022-01-10
10
20
20

2022-01-11
10
20
20

2022-01-12
10
20
10

end_date	sales	prev_sales	after_sales
2022-01-01	20	20	40
2022-01-02	20	40	30
2022-01-03	10	30	20
2022-01-04	10	20	20
2022-01-05	10	20	20
2022-01-06	10	20	20
2022-01-07	10	20	30
2022-01-08	20	30	30
2022-01-09	10	30	20
2022-01-10	10	20	20
2022-01-11	10	20	20
2022-01-12	10	20	10