MySQL 8.0

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


@@version


8.0.24


CREATE TABLE input
(ID SERIAL PRIMARY KEY
,creation_date DATE NOT NULL
);

INSERT INTO input VALUES
(1    ,  '2018-06-03'),
(2     , '2018-06-04'),
(3     , '2018-06-04'),
(4      ,'2018-06-10'),
(5      ,'2018-06-11'),
(10    ,  '2019-06-03'),
(20     , '2019-06-04'),
(30     , '2019-06-04'),
(40      ,'2019-06-10'),
(50      ,'2019-06-11');
-- SELECT * FROM my_table;  -- 10 records
select year(creation_date) as year, weekofyear(creation_date) as week,
       count(*) as number_of_starts,
       sum(count(*)) over (order by min(creation_date)) as number_of_records
from input
group by year, week;


year
week
number_of_starts
number_of_records


2018
22
1
1

2018
23
3
4

2018
24
1
5

2019
23
3
8

2019
24
2
10


SELECT YEAR(creation_date) AS year, WEEKOFYEAR(creation_date) AS week,
       COUNT(*) AS number_of_starts,
       SUM(COUNT(*)) OVER (PARTITION BY YEAR(creation_date) 
                           ORDER BY MIN(creation_date)) AS number_of_records
FROM input
GROUP BY year, week
ORDER BY YEAR(creation_date), WEEKOFYEAR(creation_date)


year
week
number_of_starts
number_of_records


2018
22
1
1

2018
23
3
4

2018
24
1
5

2019
23
3
3

2019
24
2
5


select 
  the_year, the_week, 
  sum(number_of_records) 
      OVER (PARTITION BY the_year order by the_year, the_week) AS cum_rec
from (
  select year(creation_date) as the_year, weekofyear(creation_date) as the_week,
  count(id) as number_of_records
  from input 
  group by the_year, the_week
) your_sql


the_year
the_week
cum_rec


2018
22
1

2018
23
4

2018
24
5

2019
23
3

2019
24
5